APPS.IGS_EN_WLST_GEN_PROC dependencies on IGS_PS_USEC_WLST_PRF

Line 1016: CURSOR cur_wlst_uoo_prf ( cp_priority_id igs_ps_usec_wlst_prf.unit_sec_waitlist_priority_id%TYPE)

1012: WHERE uoo_id = cp_uoo_id
1013: ORDER BY priority_number;
1014:
1015: -- Cursor to select preferences for a given priority Id at unit section level
1016: CURSOR cur_wlst_uoo_prf ( cp_priority_id igs_ps_usec_wlst_prf.unit_sec_waitlist_priority_id%TYPE)
1017: IS
1018: SELECT preference_code,preference_version
1019: FROM igs_ps_usec_wlst_prf
1020: WHERE unit_sec_waitlist_priority_id = cp_priority_id

Line 1019: FROM igs_ps_usec_wlst_prf

1015: -- Cursor to select preferences for a given priority Id at unit section level
1016: CURSOR cur_wlst_uoo_prf ( cp_priority_id igs_ps_usec_wlst_prf.unit_sec_waitlist_priority_id%TYPE)
1017: IS
1018: SELECT preference_code,preference_version
1019: FROM igs_ps_usec_wlst_prf
1020: WHERE unit_sec_waitlist_priority_id = cp_priority_id
1021: ORDER BY preference_order;
1022:
1023: -- Cursor to select maximum number of priorities at unit section level

Line 1035: FROM igs_ps_usec_wlst_prf

1031: -- Cursor to select maximum number of preferences among all the priorities at unit section level
1032: CURSOR cur_max_uoo_prf ( cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE)
1033: IS
1034: SELECT count(unit_sec_waitlist_pref_id)
1035: FROM igs_ps_usec_wlst_prf
1036: WHERE unit_sec_waitlist_priority_id IN(SELECT unit_sec_waitlist_priority_id
1037: FROM igs_ps_usec_wlst_pri
1038: WHERE uoo_id = cp_uoo_id);
1039: l_max_uoo_pref NUMBER;