APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_ENRT_RT

Line 1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_rows));

1101: benutils.write(p_text => 'Table Name No. Of Rows Deleted');
1102: benutils.write(p_text => '---------- -------------------');
1103: benutils.write(p_text => 'Ben_elig_per_f '||to_char(g_elig_rows));
1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_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));

Line 1380: delete from ben_enrt_rt

1376: if t_elctbl_chc.count > 0 then
1377: --
1378: hr_utility.set_location('delete enrt rt',1);
1379: forall i in 1..t_elctbl_chc.last
1380: delete from ben_enrt_rt
1381: where elig_per_elctbl_chc_id = t_elctbl_chc(i);
1382: g_enrt_rt_rows := g_enrt_rt_rows + sql%rowcount;
1383:
1384: forall i in 1..t_elctbl_chc.last

Line 1385: delete from ben_enrt_rt

1381: where elig_per_elctbl_chc_id = t_elctbl_chc(i);
1382: g_enrt_rt_rows := g_enrt_rt_rows + sql%rowcount;
1383:
1384: forall i in 1..t_elctbl_chc.last
1385: delete from ben_enrt_rt
1386: where enrt_bnft_id in
1387: (select enrt_bnft_id
1388: from ben_enrt_bnft
1389: where elig_per_elctbl_chc_id = t_elctbl_chc(i));