APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_ENRT_RT

Line 703: -- BEN_ENRT_RT

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: --
706: procedure delete_per_in_ler
707: is

Line 760: delete from BEN_ENRT_RT

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
762: from BEN_ELIG_PER_ELCTBL_CHC a
763: where a.PER_IN_LER_ID = l_data(i) );
764: --

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

761: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID
762: from BEN_ELIG_PER_ELCTBL_CHC a
763: where a.PER_IN_LER_ID = l_data(i) );
764: --
765: ben_batch_utils.write(p_text => 'BEN_ENRT_RT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
766: --
767: FORALL i IN 1..l_data.COUNT
768: delete from BEN_PRTT_PREM_BY_MO_F
769: where PRTT_PREM_ID IN ( select PRTT_PREM_ID