APPS.IGS_PS_VAL_UD dependencies on IGS_PS_UNIT_DSCP

Line 71: FROM IGS_PS_UNIT_DSCP

67: UV.version_number = p_version_number AND
68: UV.unit_status = US.unit_status;
69: CURSOR gc_unit_discip_exists IS
70: SELECT 'x'
71: FROM IGS_PS_UNIT_DSCP
72: WHERE unit_cd = p_unit_cd AND
73: version_number = p_version_number;
74:
75: CURSOR cur_percent IS

Line 77: FROM IGS_PS_UNIT_DSCP

73: version_number = p_version_number;
74:
75: CURSOR cur_percent IS
76: SELECT SUM(percentage)
77: FROM IGS_PS_UNIT_DSCP
78: WHERE unit_cd = p_unit_cd AND
79: version_number= p_version_number;
80:
81:

Line 108: -- and no IGS_PS_UNIT_DSCP records exists

104: RETURN TRUE;
105: ELSE
106: -- when the percentage doesn't total 100 and
107: -- when the IGS_PS_UNIT_STAT.s_unit_status is PLANNED
108: -- and no IGS_PS_UNIT_DSCP records exists
109: IF (gv_unit_status = 'PLANNED' AND gc_unit_discip_exists%NOTFOUND) AND (NOT p_b_lgcy_validator) THEN
110: CLOSE gc_unit_status;
111: CLOSE gc_unit_discip_exists;
112: p_message_name := NULL;