APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PRTT_RT_VAL

Line 833: -- BEN_PRTT_RT_VAL

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
837: --

Line 883: DELETE FROM BEN_PRTT_RT_VAL

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);
885: --
886: ben_batch_utils.write(p_text => 'BEN_PRTT_RT_VAL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
887: --

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

882: FORALL i IN 1..l_data.COUNT
883: DELETE FROM BEN_PRTT_RT_VAL
884: WHERE prtt_enrt_rslt_id = l_data(i);
885: --
886: ben_batch_utils.write(p_text => 'BEN_PRTT_RT_VAL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
887: --
888: FORALL i IN 1..l_data.COUNT
889: DELETE FROM BEN_PRTT_ENRT_RSLT_F
890: WHERE prtt_enrt_rslt_id = l_data(i);