APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 694: -- BEN_BNFT_PRVDD_LDGR_F

690: -- referenced.
691: -- Hierarchy to use
692: --
693: -- BEN_PER_IN_LER
694: -- BEN_BNFT_PRVDD_LDGR_F
695: -- BEN_CBR_PER_IN_LER
696: -- BEN_ELIG_PER_OPT_F
697: -- BEN_ELIG_DPNT
698: -- BEN_PIL_ELCTBL_CHC_POPL

Line 730: DELETE FROM BEN_BNFT_PRVDD_LDGR_F

726: LOOP
727: FETCH c2 BULK COLLECT INTO l_data;
728: --
729: FORALL i IN 1..l_data.COUNT
730: DELETE FROM BEN_BNFT_PRVDD_LDGR_F
731: WHERE PER_IN_LER_ID = l_data(i);
732: --
733: ben_batch_utils.write(p_text => 'BEN_BNFT_PRVDD_LDGR_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
734: --

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

729: FORALL i IN 1..l_data.COUNT
730: DELETE FROM BEN_BNFT_PRVDD_LDGR_F
731: WHERE PER_IN_LER_ID = l_data(i);
732: --
733: ben_batch_utils.write(p_text => 'BEN_BNFT_PRVDD_LDGR_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
734: --
735: FORALL i IN 1..l_data.COUNT
736: DELETE FROM BEN_CBR_PER_IN_LER
737: WHERE PER_IN_LER_ID = l_data(i);