APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_BATCH_BNFT_CERT_INFO

Line 568: -- BEN_BATCH_BNFT_CERT_INFO

564: -- Hierarchy to use
565: --
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

Line 609: DELETE FROM BEN_BATCH_BNFT_CERT_INFO

605: --
606: ben_batch_utils.write(p_text => 'BEN_BATCH_ACTN_ITEM_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
607: --
608: FORALL i IN 1..l_data.COUNT
609: DELETE FROM BEN_BATCH_BNFT_CERT_INFO
610: WHERE benefit_action_id = l_data(i);
611: --
612: ben_batch_utils.write(p_text => 'BEN_BATCH_BNFT_CERT_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
613: --

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

608: FORALL i IN 1..l_data.COUNT
609: DELETE FROM BEN_BATCH_BNFT_CERT_INFO
610: WHERE benefit_action_id = l_data(i);
611: --
612: ben_batch_utils.write(p_text => 'BEN_BATCH_BNFT_CERT_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
613: --
614: FORALL i IN 1..l_data.COUNT
615: DELETE FROM BEN_BATCH_COMMU_INFO
616: WHERE benefit_action_id = l_data(i);