APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_ENRT_PREM

Line 701: -- BEN_ENRT_PREM

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
703: -- BEN_ENRT_RT
704: -- BEN_ELIG_PER_ELCTBL_CHC
705: --

Line 782: delete from BEN_ENRT_PREM

778: --
779: ben_batch_utils.write(p_text => 'BEN_PRTT_PREM_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
780: --
781: FORALL i IN 1..l_data.COUNT
782: delete from BEN_ENRT_PREM
783: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID
784: from BEN_ELIG_PER_ELCTBL_CHC a
785: where a.PER_IN_LER_ID = l_data(i) );
786: --

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

783: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID
784: from BEN_ELIG_PER_ELCTBL_CHC a
785: where a.PER_IN_LER_ID = l_data(i) );
786: --
787: ben_batch_utils.write(p_text => 'BEN_ENRT_PREM : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
788: --
789: FORALL i IN 1..l_data.COUNT
790: delete from BEN_ENRT_BNFT
791: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID