DBA Data[Home] [Help]

APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_LE_CLSN_N_RSTR

Line 1122: benutils.write(p_text => 'Ben_le_clsn_n_rstr '||to_char(g_le_clsn_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));
1123: benutils.write(p_text => benutils.g_banner_minus);
1124: --
1125: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1126: --

Line 1502: delete from ben_le_clsn_n_rstr

1498: end if;
1499: end loop;
1500: --
1501: forall i in 1..t_per_in_ler2.last
1502: delete from ben_le_clsn_n_rstr
1503: where per_in_ler_id = t_per_in_ler2(i);
1504: g_le_clsn_rows := g_le_clsn_rows + sql%rowcount;
1505: --
1506: if p_delete_life_evt = 'Y' then