APPS.IGS_PS_UNIT_VER_PKG dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 132: igs_ps_unit_ofr_opt_all b

128: CURSOR c_enrollment_status (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
129: cp_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
130: SELECT 'X'
131: FROM igs_en_su_attempt_all a,
132: igs_ps_unit_ofr_opt_all b
133: WHERE a.uoo_id = b.uoo_id
134: AND b.unit_cd = cp_unit_cd
135: AND b.version_number = cp_version_number
136: AND a.unit_attempt_status IN ('ENROLLED','WAITLISTED');

Line 3342: Igs_ps_unit_ofr_opt_all us,

3338:
3339: CURSOR c_occurs(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE , cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
3340: SELECT uso.unit_section_occurrence_id
3341: FROM Igs_ps_usec_occurs_all uso,
3342: Igs_ps_unit_ofr_opt_all us,
3343: Igs_ca_inst_all ci
3344: WHERE uso.uoo_id=us.uoo_id
3345: AND us.cal_type=ci.cal_type
3346: AND us.ci_sequence_number = ci.sequence_number

Line 3358: igs_ps_unit_ofr_opt_all b,

3354:
3355: CURSOR c_title(cp_unit_cd VARCHAR2, cp_version_number NUMBER) IS
3356: SELECT a.*,a.rowid
3357: FROM igs_ps_usec_ref a ,
3358: igs_ps_unit_ofr_opt_all b,
3359: igs_ca_inst_all c
3360: WHERE a.uoo_id= b.uoo_id
3361: AND b.unit_cd= cp_unit_cd
3362: AND b.version_number = cp_version_number