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_VAL_CEPRC dependencies on IGS_PS_OF_OPT_UNT_ST

Line 98: FROM IGS_PS_OF_OPT_UNT_ST coous

94: AND us.version_number = cous.us_version_number
95: AND us.unit_set_status = uss1.unit_set_status
96: AND uss1.s_unit_set_status =cst_active
97: AND NOT EXISTS (SELECT 1
98: FROM IGS_PS_OF_OPT_UNT_ST coous
99: WHERE coous.course_cd = cous.course_cd
100: AND coous.crv_version_number = cous.crv_version_number
101: AND coous.CAL_TYPE = cous.CAL_TYPE
102: AND coous.unit_set_cd = cous.unit_set_cd

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