APPS.IGS_EN_VAL_PUSE dependencies on IGS_EN_UNIT_SET

Line 122: v_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE;

118:
119: BEGIN -- crsp_val_us_exists
120: -- This module validates the unit set exists.
121: DECLARE
122: v_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE;
123: CURSOR c_us IS
124: SELECT us.unit_set_cd
125: FROM IGS_EN_UNIT_SET us
126: WHERE us.unit_set_cd = p_unit_set_cd AND

Line 125: FROM IGS_EN_UNIT_SET us

121: DECLARE
122: v_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE;
123: CURSOR c_us IS
124: SELECT us.unit_set_cd
125: FROM IGS_EN_UNIT_SET us
126: WHERE us.unit_set_cd = p_unit_set_cd AND
127: us.version_number = p_version_number;
128: BEGIN
129: -- Set the default message number