APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 698: -- BEN_PIL_ELCTBL_CHC_POPL

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
701: -- BEN_ENRT_PREM
702: -- BEN_ENRT_BNFT

Line 754: delete from BEN_PIL_ELCTBL_CHC_POPL a

750: --
751: ben_batch_utils.write(p_text => 'BEN_ELIG_DPNT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
752: --
753: FORALL i IN 1..l_data.COUNT
754: delete from BEN_PIL_ELCTBL_CHC_POPL a
755: where PER_IN_LER_ID = l_data(i);
756: --
757: ben_batch_utils.write(p_text => 'BEN_PIL_ELCTBL_CHC_POPL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
758: --

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

753: FORALL i IN 1..l_data.COUNT
754: delete from BEN_PIL_ELCTBL_CHC_POPL a
755: where PER_IN_LER_ID = l_data(i);
756: --
757: ben_batch_utils.write(p_text => 'BEN_PIL_ELCTBL_CHC_POPL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
758: --
759: FORALL i IN 1..l_data.COUNT
760: delete from BEN_ENRT_RT
761: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID