DBA Data[Home] [Help]

APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_BATCH_LER_INFO

Line 573: -- BEN_BATCH_LER_INFO

569: -- BEN_BATCH_COMMU_INFO
570: -- BEN_BATCH_DPNT_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

Line 639: DELETE FROM BEN_BATCH_LER_INFO

635: --
636: ben_batch_utils.write(p_text => 'BEN_BATCH_ELIG_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
637: --
638: FORALL i IN 1..l_data.COUNT
639: DELETE FROM BEN_BATCH_LER_INFO
640: WHERE benefit_action_id = l_data(i);
641: --
642: ben_batch_utils.write(p_text => 'BEN_BATCH_LER_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
643: --

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

638: FORALL i IN 1..l_data.COUNT
639: DELETE FROM BEN_BATCH_LER_INFO
640: WHERE benefit_action_id = l_data(i);
641: --
642: ben_batch_utils.write(p_text => 'BEN_BATCH_LER_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
643: --
644: FORALL i IN 1..l_data.COUNT
645: DELETE FROM BEN_BATCH_RATE_INFO
646: WHERE benefit_action_id = l_data(i);