APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_REPORTING

Line 577: -- BEN_REPORTING

573: -- BEN_BATCH_LER_INFO
574: -- BEN_BATCH_RATE_INFO
575: -- BEN_BATCH_PROC_INFO
576: -- BEN_BATCH_RANGES
577: -- BEN_REPORTING
578: --
579: procedure delete_benefit_actions
580: is
581: --

Line 663: DELETE FROM BEN_REPORTING

659: --
660: ben_batch_utils.write(p_text => 'BEN_BATCH_RANGES : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
661: --
662: FORALL i IN 1..l_data.COUNT
663: DELETE FROM BEN_REPORTING
664: WHERE benefit_action_id = l_data(i);
665: --
666: ben_batch_utils.write(p_text => 'BEN_REPORTING : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
667: --

Line 666: ben_batch_utils.write(p_text => 'BEN_REPORTING : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

662: FORALL i IN 1..l_data.COUNT
663: DELETE FROM BEN_REPORTING
664: WHERE benefit_action_id = l_data(i);
665: --
666: ben_batch_utils.write(p_text => 'BEN_REPORTING : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
667: --
668: FORALL i IN 1..l_data.COUNT
669: DELETE FROM ben_benefit_actions
670: WHERE benefit_action_id = l_data(i);