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_WLST_GEN_PROC dependencies on IGS_PS_UOFR_WLST_PRF

Line 1064: CURSOR cur_wlst_uop_prf ( cp_priority_id igs_ps_uofr_wlst_prf.unit_ofr_waitlist_priority_id%TYPE)

1060: AND ci_sequence_number = cp_seq_no
1061: ORDER BY priority_number;
1062:
1063: -- Cursor to select preferences for a given priority Id at unit offering pattern level
1064: CURSOR cur_wlst_uop_prf ( cp_priority_id igs_ps_uofr_wlst_prf.unit_ofr_waitlist_priority_id%TYPE)
1065: IS
1066: SELECT preference_code,preference_version
1067: FROM igs_ps_uofr_wlst_prf
1068: WHERE unit_ofr_waitlist_priority_id = cp_priority_id

Line 1067: FROM igs_ps_uofr_wlst_prf

1063: -- Cursor to select preferences for a given priority Id at unit offering pattern level
1064: CURSOR cur_wlst_uop_prf ( cp_priority_id igs_ps_uofr_wlst_prf.unit_ofr_waitlist_priority_id%TYPE)
1065: IS
1066: SELECT preference_code,preference_version
1067: FROM igs_ps_uofr_wlst_prf
1068: WHERE unit_ofr_waitlist_priority_id = cp_priority_id
1069: ORDER BY preference_order;
1070:
1071: -- Cursor to select maximum number of priorities at unit offering pattern level

Line 1092: FROM igs_ps_uofr_wlst_prf

1088: cp_cal_type igs_ps_uofr_wlst_pri.calender_type%TYPE ,
1089: cp_seq_no igs_ps_uofr_wlst_pri.ci_sequence_number%TYPE)
1090: IS
1091: SELECT count(unit_ofr_waitlist_pref_id)
1092: FROM igs_ps_uofr_wlst_prf
1093: WHERE unit_ofr_waitlist_priority_id IN(SELECT unit_ofr_waitlist_priority_id
1094: FROM igs_ps_uofr_wlst_pri
1095: WHERE unit_cd = cp_unit_cd
1096: AND version_number = cp_version_number