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

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

442: Who When What
443:
444: (reverse chronological order - newest change first)
445: ***************************************************************/
446: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
447: SELECT uso.unit_section_occurrence_id
448: FROM igs_ps_usec_occurs_all uso
449: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
450: AND uso.no_set_day_ind ='N'

Line 448: FROM igs_ps_usec_occurs_all uso

444: (reverse chronological order - newest change first)
445: ***************************************************************/
446: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
447: SELECT uso.unit_section_occurrence_id
448: FROM igs_ps_usec_occurs_all uso
449: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
450: AND uso.no_set_day_ind ='N'
451: AND uso.unit_section_occurrence_id=cp_unit_section_occurrence_id;
452: