APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_ELIG_PER_OPT_F

Line 696: -- BEN_ELIG_PER_OPT_F

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
699: -- BEN_PRTT_PREM_BY_MO_F
700: -- BEN_PRTT_PREM_F

Line 742: DELETE FROM BEN_ELIG_PER_OPT_F

738: --
739: ben_batch_utils.write(p_text => 'BEN_CBR_PER_IN_LER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
740: --
741: FORALL i IN 1..l_data.COUNT
742: DELETE FROM BEN_ELIG_PER_OPT_F
743: WHERE PER_IN_LER_ID = l_data(i);
744: --
745: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_OPT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
746: --

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

741: FORALL i IN 1..l_data.COUNT
742: DELETE FROM BEN_ELIG_PER_OPT_F
743: WHERE PER_IN_LER_ID = l_data(i);
744: --
745: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_OPT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
746: --
747: FORALL i IN 1..l_data.COUNT
748: delete from BEN_ELIG_DPNT a
749: where PER_IN_LER_ID = l_data(i);