APPS.IGS_PS_GEN_007 dependencies on IGS_PS_UNIT_STAT

Line 169: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

165: --who when what
166: --sarakshi 12-Apr-2006 Bug#3655441, modified procedure crsp_ins_cow_hist to include PLANNED status also
167:
168: AS
169: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
170: CURSOR c_get_unit_status IS
171: SELECT s_unit_status
172: FROM IGS_PS_UNIT_STAT, IGS_PS_UNIT_VER
173: WHERE IGS_PS_UNIT_VER.unit_cd = p_unit_cd AND

Line 172: FROM IGS_PS_UNIT_STAT, IGS_PS_UNIT_VER

168: AS
169: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
170: CURSOR c_get_unit_status IS
171: SELECT s_unit_status
172: FROM IGS_PS_UNIT_STAT, IGS_PS_UNIT_VER
173: WHERE IGS_PS_UNIT_VER.unit_cd = p_unit_cd AND
174: IGS_PS_UNIT_VER.version_number = p_version_number AND
175: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
176:

Line 175: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;

171: SELECT s_unit_status
172: FROM IGS_PS_UNIT_STAT, IGS_PS_UNIT_VER
173: WHERE IGS_PS_UNIT_VER.unit_cd = p_unit_cd AND
174: IGS_PS_UNIT_VER.version_number = p_version_number AND
175: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
176:
177: x_rowid Varchar2(25);
178: l_org_id NUMBER(15);
179: BEGIN