APPS.BEN_DET_IMPUTED_INCOME dependencies on BEN_LE_CLSN_N_RSTR

Line 217: from BEN_LE_CLSN_N_RSTR lcnr

213: --
214: cursor c_corr_result_exist (l_per_in_ler_id number ,
215: l_prtt_enrt_rslt_id number ) is
216: select lcnr.*
217: from BEN_LE_CLSN_N_RSTR lcnr
218: where lcnr.bkup_tbl_id = l_prtt_enrt_rslt_id
219: and lcnr.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_CORR'
220: and lcnr.enrt_cvg_thru_dt = hr_api.g_eot
221: and lcnr.Per_in_ler_ended_id = l_per_in_ler_id;

Line 371: delete from BEN_LE_CLSN_N_RSTR

367: and business_group_id = p_business_group_id
368: and person_id = l_corr_pen_rec.person_id;
369:
370: if sql%rowcount > 0 then
371: delete from BEN_LE_CLSN_N_RSTR
372: where bkup_tbl_id = nvl(l_corr_pen_rec.bkup_tbl_id,-1)
373: and Per_in_ler_ended_id = nvl(l_imp_inc_enrt_tab(r).per_in_ler_id,-1)
374: and BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_CORR';
375: end if;