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_USO_FACILITY_PKG dependencies on IGS_PS_USEC_OCCURS_ALL

Line 361: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

357: Change History
358: Who When What
359: (reverse chronological order - newest change first)
360: ***************************************************************/
361: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
362: SELECT uso.unit_section_occurrence_id
363: FROM igs_ps_usec_occurs_all uso
364: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
365: AND uso.no_set_day_ind ='N'

Line 363: FROM igs_ps_usec_occurs_all uso

359: (reverse chronological order - newest change first)
360: ***************************************************************/
361: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
362: SELECT uso.unit_section_occurrence_id
363: FROM igs_ps_usec_occurs_all uso
364: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
365: AND uso.no_set_day_ind ='N'
366: AND uso.unit_section_occurrence_id=cp_unit_section_occurrence_id;
367: