APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));

1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_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));

Line 1300: from ben_elig_per_elctbl_chc epe

1296: ler.effective_end_date));
1297: --
1298: cursor c_elctbl_chc (p_per_in_ler_id number) is
1299: select elig_per_elctbl_chc_id
1300: from ben_elig_per_elctbl_chc epe
1301: where epe.per_in_ler_id = p_per_in_ler_id;
1302: --
1303: cursor c_prtt_enrt_rslt (p_per_in_ler_id number) is
1304: select prtt_enrt_rslt_id

Line 1430: from ben_elig_per_elctbl_chc

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));
1432: g_pil_elctbl_chc_popl_rows := g_pil_elctbl_chc_popl_rows + sql%rowcount;
1433: */
1434:

Line 1437: delete from ben_elig_per_elctbl_chc

1433: */
1434:
1435: --
1436: forall i in 1..t_elctbl_chc.last
1437: delete from ben_elig_per_elctbl_chc
1438: where elig_per_elctbl_chc_id = t_elctbl_chc(i);
1439: g_elig_per_elctbl_chc_rows := g_elig_per_elctbl_chc_rows + sql%rowcount;
1440: --
1441: forall i in 1..t_elctbl_chc.last