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.

APPS.IGS_PS_VAL_CEPRC dependencies on IGS_EN_UNIT_SET_STAT

Line 85: FROM IGS_PS_OFR_UNIT_SET cous,IGS_PS_OFR_OPT coo,igs_en_unit_set_stat uss1,IGS_EN_UNIT_SET_ALL US

81: cst_true CONSTANT VARCHAR2(5) := 'TRUE';
82: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
83: CURSOR c_uss IS
84: SELECT 'X'
85: FROM IGS_PS_OFR_UNIT_SET cous,IGS_PS_OFR_OPT coo,igs_en_unit_set_stat uss1,IGS_EN_UNIT_SET_ALL US
86: WHERE coo.coo_id = p_coo_id
87: AND us.version_number = p_us_version_number
88: AND us.unit_set_cd = p_unit_set_cd
89: AND us.expiry_dt IS NULL

Line 107: FROM IGS_PS_OF_OPT_UNT_ST coous,IGS_EN_UNIT_SET_ALL US,igs_en_unit_set_stat uss1

103: AND coous.us_version_number = cous.us_version_number
104: );
105: CURSOR c_uss1 IS
106: SELECT 'X'
107: FROM IGS_PS_OF_OPT_UNT_ST coous,IGS_EN_UNIT_SET_ALL US,igs_en_unit_set_stat uss1
108: WHERE coous.coo_id = p_coo_id
109: AND us.version_number = p_us_version_number
110: AND us.unit_set_cd = p_unit_set_cd
111: AND us.expiry_dt IS NULL