APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PRTT_PREM_BY_MO_F

Line 699: -- BEN_PRTT_PREM_BY_MO_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
703: -- BEN_ENRT_RT

Line 768: delete from BEN_PRTT_PREM_BY_MO_F

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
770: from BEN_PRTT_PREM_F a
771: where a.PER_IN_LER_ID = l_data(i) );
772: --

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

769: where PRTT_PREM_ID IN ( select PRTT_PREM_ID
770: from BEN_PRTT_PREM_F a
771: where a.PER_IN_LER_ID = l_data(i) );
772: --
773: ben_batch_utils.write(p_text => 'BEN_PRTT_PREM_BY_MO_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
774: --
775: FORALL i IN 1..l_data.COUNT
776: delete from BEN_PRTT_PREM_F a
777: where PER_IN_LER_ID = l_data(i);