APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PRTT_PREM_F

Line 700: -- BEN_PRTT_PREM_F

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
704: -- BEN_ELIG_PER_ELCTBL_CHC

Line 770: from BEN_PRTT_PREM_F a

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: --
773: ben_batch_utils.write(p_text => 'BEN_PRTT_PREM_BY_MO_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
774: --

Line 776: delete from BEN_PRTT_PREM_F a

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);
778: --
779: ben_batch_utils.write(p_text => 'BEN_PRTT_PREM_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
780: --

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

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);
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

Line 832: -- BEN_PRTT_PREM_F

828: -- BEN_PRTT_ENRT_RSLT_F
829: -- BEN_PRMRY_CARE_PRVDR_F
830: -- BEN_PRTT_ENRT_ACTN_F
831: -- BEN_PRTT_ENRT_CTFN_PRVDD_F
832: -- BEN_PRTT_PREM_F
833: -- BEN_PRTT_RT_VAL
834: --
835: procedure delete_prtt_enrt_rslt_f
836: is

Line 877: DELETE FROM BEN_PRTT_PREM_F

873: --
874: ben_batch_utils.write(p_text => 'BEN_PRTT_ENRT_CTFN_PRVDD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
875: --
876: FORALL i IN 1..l_data.COUNT
877: DELETE FROM BEN_PRTT_PREM_F
878: WHERE prtt_enrt_rslt_id = l_data(i);
879: --
880: ben_batch_utils.write(p_text => 'BEN_PRTT_PREM_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
881: --

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

876: FORALL i IN 1..l_data.COUNT
877: DELETE FROM BEN_PRTT_PREM_F
878: WHERE prtt_enrt_rslt_id = l_data(i);
879: --
880: ben_batch_utils.write(p_text => 'BEN_PRTT_PREM_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
881: --
882: FORALL i IN 1..l_data.COUNT
883: DELETE FROM BEN_PRTT_RT_VAL
884: WHERE prtt_enrt_rslt_id = l_data(i);