APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_EXT_CRIT_VAL

Line 914: -- BEN_EXT_CRIT_VAL

910: -- referenced.
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

Line 947: DELETE FROM ben_ext_crit_val

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 (
949: SELECT DISTINCT ext_crit_val_id
950: FROM ben_ext_crit_val val, ben_ext_crit_typ typ
951: WHERE typ.crit_typ_cd = 'PID'

Line 950: FROM ben_ext_crit_val val, ben_ext_crit_typ typ

946: FORALL i IN 1..l_data.COUNT
947: DELETE FROM ben_ext_crit_val
948: WHERE ext_crit_val_id IN (
949: SELECT DISTINCT ext_crit_val_id
950: FROM ben_ext_crit_val val, ben_ext_crit_typ typ
951: WHERE typ.crit_typ_cd = 'PID'
952: AND val.ext_crit_typ_id = typ.ext_crit_typ_id
953: AND val.val_1 = TO_CHAR (l_data (i)));
954: --

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

951: WHERE typ.crit_typ_cd = 'PID'
952: AND val.ext_crit_typ_id = typ.ext_crit_typ_id
953: AND val.val_1 = TO_CHAR (l_data (i)));
954: --
955: ben_batch_utils.write(p_text => 'BEN_EXT_CRIT_VAL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
956: --
957: FORALL i IN 1..l_data.COUNT
958: DELETE FROM ben_elig_cvrd_dpnt_f
959: WHERE elig_cvrd_dpnt_id = l_data (i);