APPS.IGS_PR_GEN_004 dependencies on IGS_AS_SC_ATMPT_ENR

Line 457: FROM IGS_AS_SC_ATMPT_ENR scae,

453: OR
454: EXISTS
455: (
456: SELECT 'X'
457: FROM IGS_AS_SC_ATMPT_ENR scae,
458: IGS_CA_INST ci1
459: WHERE sca.person_id = scae.person_id AND
460: sca.course_cd = scae.course_cd AND
461: scae.enrolment_cat = p_enrolment_cat AND

Line 467: FROM IGS_AS_SC_ATMPT_ENR scae2,

463: ci1.sequence_number = scae.ci_sequence_number AND
464: ci1.end_dt =
465: (
466: SELECT MAX(ci2.end_dt)
467: FROM IGS_AS_SC_ATMPT_ENR scae2,
468: IGS_CA_INST ci2
469: WHERE
470: scae2.person_id = scae.person_id AND
471: scae2.course_cd = scae.course_cd AND

Line 2875: FROM igs_as_sc_atmpt_enr scae,

2871: cp_person_id IN NUMBER,
2872: cp_course_cd IN VARCHAR2
2873: ) IS
2874: SELECT scae.enrolment_cat enrolment_cat
2875: FROM igs_as_sc_atmpt_enr scae,
2876: igs_ca_inst_all ci
2877: WHERE scae.person_id = cp_person_id
2878: AND scae.course_cd = cp_course_cd
2879: AND scae.cal_type = ci.cal_type

Line 3130: FROM IGS_AS_SC_ATMPT_ENR scae,

3126: sca.progression_status = p_progression_status) AND
3127: (p_enrolment_cat IS NULL OR
3128: EXISTS (
3129: SELECT 'X'
3130: FROM IGS_AS_SC_ATMPT_ENR scae,
3131: IGS_CA_INST ci1
3132: WHERE sca.person_id = scae.person_id AND
3133: sca.course_cd = scae.course_cd AND
3134: scae.enrolment_cat = p_enrolment_cat AND

Line 3139: FROM IGS_AS_SC_ATMPT_ENR scae2,

3135: ci1.cal_type = scae.cal_type AND
3136: ci1.sequence_number = scae.ci_sequence_number AND
3137: ci1.end_dt =
3138: (SELECT MAX(ci2.end_dt)
3139: FROM IGS_AS_SC_ATMPT_ENR scae2,
3140: IGS_CA_INST ci2
3141: WHERE scae2.person_id = scae.person_id AND
3142: scae2.course_cd = scae.course_cd AND
3143: ci2.cal_type = scae2.cal_type AND