DBA Data[Home] [Help]

APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_PL_BNF_F

Line 732: delete from ben_pl_bnf_f t

728: where business_group_id = p_business_group_id
729: and not exists ( select 1 from ben_per_in_ler p
730: where p.per_in_ler_id = t.per_in_ler_id ) ;
731:
732: delete from ben_pl_bnf_f t
733: where business_group_id = p_business_group_id
734: and not exists ( select 1 from ben_per_in_ler p
735: where p.per_in_ler_id = t.per_in_ler_id );
736: --

Line 1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_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));
1122: benutils.write(p_text => 'Ben_le_clsn_n_rstr '||to_char(g_le_clsn_rows));

Line 1488: delete from ben_pl_bnf_f

1484: g_prtt_enrt_rslt_rows := g_prtt_enrt_rslt_rows + sql%rowcount;
1485: --
1486: forall i in 1..t_rslt.last
1487: --
1488: delete from ben_pl_bnf_f
1489: where prtt_enrt_rslt_id = t_rslt(i);
1490: g_pl_bnf_rows := g_pl_bnf_rows + sql%rowcount;
1491: --
1492: forall i in 1..t_rslt.last