>
>	
>	
>DECLARE
>	CURSOR CUR_POST IS 
>	SELECT DISTINCT PL_EST_MH.EST_M
>	FROM PL_EST_MH
>	WHERE PL_EST_MH.EST_C = :RC_RCVRYNTC_T.EST_C;
>	
> 	CURSOR C1 IS
>	SELECT PARTY_M,ACTPOSS_D,at_altmnt_t.ALTMNTDT_D,ACTLPLTNO_N,ACCT_C
>	FROM AT_APPLCNT_MH,AT_ALTMNT_T,PL_ESTPLTMIX_MD,CO_PARTY_M
>	WHERE AT_APPLCNT_MH.APLICD_C = :RC_RCVRYNTC_T.APLCNT_C
>	AND CO_PARTY_M.PARTY_C = AT_APPLCNT_MH.ACCT_C
>	AND AT_ALTMNT_T.PLOTCD_C = PL_ESTPLTMIX_MD.ESTPLTMIX_C
>	AND AT_APPLCNT_MH.APLICD_C = AT_ALTMNT_T.APLICD_C;
>	
>BEGIN
>	OPEN CUR_POST;
>	FETCH CUR_POST INTO :RC_RCVRYNTC_T.EST_M;
>	CLOSE CUR_POST;
>	
>	OPEN C1;
>	FETCH C1 INTO :RC_RCVRYNTC_T.APPLCNT_NAME,
>	:RC_RCVRYNTC_T.POSSTKNON_D,
>	:RC_RCVRYNTC_T.ALTMNT_D,
>  :RC_RCVRYNTC_T.PLOT_N,:RC_RCVRYNTC_T.ACCNTNT_CD;
>	CLOSE C1;