APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_PRTT_ENRT_RSLT_F

Line 1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_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));
1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));
1116: benutils.write(p_text => 'Ben_elig_cvrd_dpnt_f '||to_char(g_elig_cvrd_dpnt_rows));
1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_rows));
1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_rows));
1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));
1120: benutils.write(p_text => 'Ben_per_in_ler '||to_char(g_per_in_ler_rows));
1121: benutils.write(p_text => 'Ben_ptnl_ler_for_per '||to_char(g_ptnl_ler_rows));

Line 1305: from ben_prtt_enrt_rslt_f pen

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
1305: from ben_prtt_enrt_rslt_f pen
1306: where pen.per_in_ler_id = p_per_in_ler_id
1307: and pen.prtt_enrt_rslt_stat_cd in ('BCKDT','VOIDD');
1308: --
1309: type per_in_tab is table of ben_per_in_ler.per_in_ler_id%type

Line 1482: delete from ben_prtt_enrt_rslt_f

1478: g_elig_cvrd_dpnt_rows := g_elig_cvrd_dpnt_rows + sql%rowcount;
1479: --
1480: forall i in 1..t_rslt.last
1481: --
1482: delete from ben_prtt_enrt_rslt_f
1483: where prtt_enrt_rslt_id = t_rslt(i);
1484: g_prtt_enrt_rslt_rows := g_prtt_enrt_rslt_rows + sql%rowcount;
1485: --
1486: forall i in 1..t_rslt.last