APPS.IGS_PS_VAL_UD dependencies on IGS_PS_UNIT_VER

Line 39: -- Validate IGS_PS_UNIT IGS_PS_DSCP percentage for the IGS_PS_UNIT version

35: IGS_GE_MSG_STACK.ADD;
36: App_Exception.Raise_Exception;
37: END crsp_val_ud_dg_cd;
38: --
39: -- Validate IGS_PS_UNIT IGS_PS_DSCP percentage for the IGS_PS_UNIT version
40: FUNCTION crsp_val_ud_perc(
41: p_unit_cd IN VARCHAR2 ,
42: p_version_number IN NUMBER ,
43: p_message_name OUT NOCOPY VARCHAR2,

Line 64: FROM IGS_PS_UNIT_VER UV,

60: gv_unit_discip_exists CHAR;
61: gv_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
62: CURSOR gc_unit_status IS
63: SELECT US.s_unit_status
64: FROM IGS_PS_UNIT_VER UV,
65: IGS_PS_UNIT_STAT US
66: WHERE UV.unit_cd = p_unit_cd AND
67: UV.version_number = p_version_number AND
68: UV.unit_status = US.unit_status;