APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_BATCH_RANGES

Line 576: -- BEN_BATCH_RANGES

572: -- BEN_BATCH_ELIG_INFO
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

Line 657: DELETE FROM BEN_BATCH_RANGES

653: --
654: ben_batch_utils.write(p_text => 'BEN_BATCH_PROC_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
655: --
656: FORALL i IN 1..l_data.COUNT
657: DELETE FROM BEN_BATCH_RANGES
658: WHERE benefit_action_id = l_data(i);
659: --
660: ben_batch_utils.write(p_text => 'BEN_BATCH_RANGES : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
661: --

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

656: FORALL i IN 1..l_data.COUNT
657: DELETE FROM BEN_BATCH_RANGES
658: WHERE benefit_action_id = l_data(i);
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);