APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));

1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));
1107: benutils.write(p_text => 'Ben_enrt_bnft '||to_char(g_enrt_bnft_rows));
1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_rows));
1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));
1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));
1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_rows));
1112: benutils.write(p_text => 'Ben_prtt_rt_val '||to_char(g_prtt_rt_rows));
1113: benutils.write(p_text => 'Ben_prtt_enrt_actn_f '||to_char(g_prtt_enrt_actn_rows));
1114: benutils.write(p_text => 'Ben_prtt_prem_f '||to_char(g_prtt_prem_rows));

Line 1356: delete from ben_pil_elctbl_chc_popl pel

1352: if t_per_in_ler2.count > 0 then
1353: --
1354: -- added here during bug fix 3670708
1355: forall i in 1..t_per_in_ler2.last
1356: delete from ben_pil_elctbl_chc_popl pel
1357: where pel.per_in_ler_id = t_per_in_ler2(i);
1358: g_pil_elctbl_chc_popl_rows := g_pil_elctbl_chc_popl_rows + sql%rowcount;
1359: --
1360: -- End of bug fix 3670708

Line 1427: delete from ben_pil_elctbl_chc_popl pel

1423: --
1424: -- Commented it out and deleting this thru per_in_ler above Bug 3670708
1425: /*
1426: forall i in 1..t_elctbl_chc.last
1427: delete from ben_pil_elctbl_chc_popl pel
1428: where pel.pil_elctbl_chc_popl_id =
1429: (select pil_elctbl_chc_popl_id
1430: from ben_elig_per_elctbl_chc
1431: where elig_per_elctbl_chc_id = t_elctbl_chc(i));