DBA Data[Home] [Help]

APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_ELIG_PER_OPT_F

Line 1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_rows));

1100: benutils.write(p_text => benutils.g_banner_minus);
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));

Line 1345: delete from ben_elig_per_opt_f epo

1341: where pep.per_in_ler_id = t_per_in_ler(i);
1342: g_elig_rows := g_elig_rows + sql%rowcount;
1343: --
1344: forall i in 1..t_per_in_ler.last
1345: delete from ben_elig_per_opt_f epo
1346: where epo.per_in_ler_id = t_per_in_ler(i);
1347: g_elig_per_rows := g_elig_per_rows + sql%rowcount;
1348: --
1349: end if;