[Home] [Help]
APPS.IGS_ST_VAL_ULA dependencies on IGS_PS_UNIT_VER
Line 20: FROM IGS_PS_UNIT_VER uv,
16: DECLARE
17: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
18: CURSOR c_uv IS
19: SELECT us.s_unit_status
20: FROM IGS_PS_UNIT_VER uv,
21: IGS_PS_UNIT_STAT us
22: WHERE uv.unit_cd = p_unit_cd AND
23: uv.version_number = p_version_number AND
24: us.unit_status = uv.unit_status;