APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_CVRD_DPNT_CTFN_PRVDD_F

Line 915: -- BEN_CVRD_DPNT_CTFN_PRVDD_F

911: -- Hierarchy to use
912: --
913: -- BEN_ELIG_CVRD_DPNT_F
914: -- BEN_EXT_CRIT_VAL
915: -- BEN_CVRD_DPNT_CTFN_PRVDD_F
916: --
917: procedure delete_elig_cvrd_dpnt_f
918: is
919: --

Line 941: DELETE FROM ben_cvrd_dpnt_ctfn_prvdd_f

937: LOOP
938: FETCH c4 BULK COLLECT INTO l_data ;
939: --
940: FORALL i IN 1..l_data.COUNT
941: DELETE FROM ben_cvrd_dpnt_ctfn_prvdd_f
942: WHERE elig_cvrd_dpnt_id = l_data (i);
943: --
944: ben_batch_utils.write(p_text => 'BEN_CVRD_DPNT_CTFN_PRVDD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
945: --

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

940: FORALL i IN 1..l_data.COUNT
941: DELETE FROM ben_cvrd_dpnt_ctfn_prvdd_f
942: WHERE elig_cvrd_dpnt_id = l_data (i);
943: --
944: ben_batch_utils.write(p_text => 'BEN_CVRD_DPNT_CTFN_PRVDD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
945: --
946: FORALL i IN 1..l_data.COUNT
947: DELETE FROM ben_ext_crit_val
948: WHERE ext_crit_val_id IN (