APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_BATCH_PROC_INFO

Line 575: -- BEN_BATCH_PROC_INFO

571: -- BEN_BATCH_ELCTBL_CHC_INFO
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

Line 651: DELETE FROM BEN_BATCH_PROC_INFO

647: --
648: ben_batch_utils.write(p_text => 'BEN_BATCH_RATE_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
649: --
650: FORALL i IN 1..l_data.COUNT
651: DELETE FROM BEN_BATCH_PROC_INFO
652: WHERE benefit_action_id = l_data(i);
653: --
654: ben_batch_utils.write(p_text => 'BEN_BATCH_PROC_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
655: --

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

650: FORALL i IN 1..l_data.COUNT
651: DELETE FROM BEN_BATCH_PROC_INFO
652: WHERE benefit_action_id = l_data(i);
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);