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

Line 832: FROM IGS_PS_OF_OPT_UNT_ST coous

828: AND us.version_number = cous.us_version_number
829: AND us.unit_set_status = uss1.unit_set_status
830: AND uss1.s_unit_set_status ='ACTIVE'
831: AND NOT EXISTS (SELECT 1
832: FROM IGS_PS_OF_OPT_UNT_ST coous
833: WHERE coous.coo_id= spa.coo_id
834: );
835:
836:

Line 839: FROM IGS_PS_OF_OPT_UNT_ST coous,

835:
836:
837: CURSOR c_usoo IS
838: SELECT 'X'
839: FROM IGS_PS_OF_OPT_UNT_ST coous,
840: IGS_EN_UNIT_SET_ALL US,
841: igs_en_unit_set_stat uss1,
842: IGS_EN_STDNT_PS_ATT spa
843: WHERE spa.person_id = p_person_id