APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PRMRY_CARE_PRVDR_F

Line 829: -- BEN_PRMRY_CARE_PRVDR_F

825: -- referenced.
826: -- Hierarchy to use
827: --
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

Line 859: DELETE FROM BEN_PRMRY_CARE_PRVDR_F

855: LOOP
856: FETCH c3 BULK COLLECT INTO l_data;
857: --
858: FORALL i IN 1..l_data.COUNT
859: DELETE FROM BEN_PRMRY_CARE_PRVDR_F
860: WHERE prtt_enrt_rslt_id = l_data(i);
861: --
862: ben_batch_utils.write(p_text => 'BEN_PRMRY_CARE_PRVDR_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
863: --

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

858: FORALL i IN 1..l_data.COUNT
859: DELETE FROM BEN_PRMRY_CARE_PRVDR_F
860: WHERE prtt_enrt_rslt_id = l_data(i);
861: --
862: ben_batch_utils.write(p_text => 'BEN_PRMRY_CARE_PRVDR_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
863: --
864: FORALL i IN 1..l_data.COUNT
865: DELETE FROM BEN_PRTT_ENRT_ACTN_F
866: WHERE prtt_enrt_rslt_id = l_data(i);