APPS.IGS_ST_VAL_ULA dependencies on IGS_PS_UNIT_STAT

Line 17: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

13: RETURN BOOLEAN IS
14: gv_other_detail VARCHAR2(255);
15: BEGIN
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

Line 21: IGS_PS_UNIT_STAT us

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;
25: BEGIN