APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_BATCH_DPNT_INFO

Line 570: -- BEN_BATCH_DPNT_INFO

566: -- BEN_BENEFIT_ACTIONS
567: -- BEN_BATCH_ACTN_ITEM_INFO
568: -- BEN_BATCH_BNFT_CERT_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

Line 621: DELETE FROM BEN_BATCH_DPNT_INFO

617: --
618: ben_batch_utils.write(p_text => 'BEN_BATCH_COMMU_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
619: --
620: FORALL i IN 1..l_data.COUNT
621: DELETE FROM BEN_BATCH_DPNT_INFO
622: WHERE benefit_action_id = l_data(i);
623: --
624: ben_batch_utils.write(p_text => 'BEN_BATCH_DPNT_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
625: --

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

620: FORALL i IN 1..l_data.COUNT
621: DELETE FROM BEN_BATCH_DPNT_INFO
622: WHERE benefit_action_id = l_data(i);
623: --
624: ben_batch_utils.write(p_text => 'BEN_BATCH_DPNT_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
625: --
626: FORALL i IN 1..l_data.COUNT
627: DELETE FROM BEN_BATCH_ELCTBL_CHC_INFO
628: WHERE benefit_action_id = l_data(i);