APPS.IGS_EN_GEN_012 dependencies on IGS_AS_SC_ATMPT_ENR

Line 1669: FROM IGS_AS_SC_ATMPT_ENR scae

1665: = 'Y')) AND
1666: (p_enrolment_cat = '%' OR
1667: EXISTS (
1668: SELECT 'X'
1669: FROM IGS_AS_SC_ATMPT_ENR scae
1670: WHERE scae.person_id = sca.person_id AND
1671: scae.course_cd = sca.course_cd AND
1672: Igs_En_Gen_014.enrs_get_within_ci(p_acad_cal_type,
1673: p_acad_sequence_number,

Line 1679: CURSOR c_scae_ci (cp_person_id IGS_AS_SC_ATMPT_ENR.person_id%TYPE,

1675: scae.ci_sequence_number,
1676: 'Y')
1677: = 'Y' AND
1678: scae.enrolment_cat LIKE p_enrolment_cat));
1679: CURSOR c_scae_ci (cp_person_id IGS_AS_SC_ATMPT_ENR.person_id%TYPE,
1680: cp_course_cd IGS_AS_SC_ATMPT_ENR.course_cd%TYPE) IS
1681: SELECT scae.person_id,
1682: scae.course_cd,
1683: scae.cal_type,

Line 1680: cp_course_cd IGS_AS_SC_ATMPT_ENR.course_cd%TYPE) IS

1676: 'Y')
1677: = 'Y' AND
1678: scae.enrolment_cat LIKE p_enrolment_cat));
1679: CURSOR c_scae_ci (cp_person_id IGS_AS_SC_ATMPT_ENR.person_id%TYPE,
1680: cp_course_cd IGS_AS_SC_ATMPT_ENR.course_cd%TYPE) IS
1681: SELECT scae.person_id,
1682: scae.course_cd,
1683: scae.cal_type,
1684: scae.ci_sequence_number,

Line 1686: FROM IGS_AS_SC_ATMPT_ENR scae,

1682: scae.course_cd,
1683: scae.cal_type,
1684: scae.ci_sequence_number,
1685: scae.enr_form_due_dt
1686: FROM IGS_AS_SC_ATMPT_ENR scae,
1687: IGS_CA_INST ci
1688: WHERE scae.person_id = cp_person_id AND
1689: scae.course_cd = cp_course_cd AND
1690: ci.cal_type = scae.cal_type AND

Line 2484: FROM IGS_AS_SC_ATMPT_ENR scae

2480: WHERE sua.person_id = sca.person_id AND
2481: sua.unit_attempt_status = 'ENROLLED' AND
2482: sua.ci_start_dt <= SYSDATE) AND
2483: NOT EXISTS ( SELECT 'x'
2484: FROM IGS_AS_SC_ATMPT_ENR scae
2485: WHERE scae.person_id = sca.person_id AND
2486: scae.course_cd = sca.course_cd AND
2487: Igs_En_Gen_004.ENRP_GET_SCAE_DUE(
2488: scae.person_id,