APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_UNIT_OFR_PAT_ALL

Line 2993: FROM igs_ps_unit_ofr_pat_all a,

2989: WHERE uoo_id = cp_n_uoo_id;
2990:
2991: CURSOR c_waitlist_allowed (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2992: SELECT waitlist_allowed
2993: FROM igs_ps_unit_ofr_pat_all a,
2994: igs_ps_unit_ofr_opt_all b
2995: WHERE b.uoo_id = cp_n_uoo_id
2996: AND a.unit_cd = b.unit_cd
2997: AND a.version_number = b.version_number

Line 3038: l_c_waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%TYPE;

3034:
3035: l_max_auditors_allowed igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;
3036: l_ctx_value igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE := p_usec_rec.max_auditors_allowed;
3037: l_count NUMBER;
3038: l_c_waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%TYPE;
3039: l_message_name VARCHAR2(30);
3040:
3041: l_n_enr_max IGS_PS_USEC_LIM_WLST.ENROLLMENT_MAXIMUM%TYPE;
3042: l_n_wlst_max IGS_PS_USEC_LIM_WLST.MAX_STUDENTS_PER_WAITLIST%TYPE;

Line 4024: FROM igs_ps_unit_ofr_pat_all

4020: cp_version_number igs_ps_unit_ver_all.version_number%type,
4021: cp_unit_cd igs_ps_unit_ver_all.unit_cd%type
4022: ) IS
4023: SELECT 'X'
4024: FROM igs_ps_unit_ofr_pat_all
4025: WHERE cal_type= cp_cal_type
4026: AND ci_sequence_number=cp_seq_num
4027: AND unit_cd = cp_unit_cd
4028: AND version_number=cp_version_number

Line 4118: FROM igs_ps_unit_ofr_pat_all pt, igs_ps_unit_ofr_opt_all uoo

4114: c_usec_chk_rec c_usec_chk%ROWTYPE;
4115:
4116: CURSOR c_pattern_chk(cp_n_uoo_id IN NUMBER) IS
4117: SELECT 'X'
4118: FROM igs_ps_unit_ofr_pat_all pt, igs_ps_unit_ofr_opt_all uoo
4119: WHERE uoo.uoo_id= cp_n_uoo_id
4120: AND uoo.unit_cd=pt.unit_cd
4121: AND uoo.version_number=pt.version_number
4122: AND uoo.cal_type= pt.cal_type