eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_PS_GEN_007 dependencies on IGS_PS_UNIT_VER

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 173: WHERE IGS_PS_UNIT_VER.unit_cd = p_unit_cd AND

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:
177: x_rowid Varchar2(25);

Line 174: IGS_PS_UNIT_VER.version_number = p_version_number AND

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:
177: x_rowid Varchar2(25);
178: l_org_id NUMBER(15);

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