APPS.IGS_EN_GEN_008 dependencies on IGS_AS_SC_ATMPT_ENR

Line 1227: FROM IGS_AS_SC_ATMPT_ENR

1223: -- already been pre-enrolled and whether they may require a IGS_PS_UNIT pre-enrolment
1224: (
1225: NOT EXISTS (
1226: SELECT person_id
1227: FROM IGS_AS_SC_ATMPT_ENR
1228: WHERE person_id = sca.person_id AND
1229: course_cd = sca.course_cd AND
1230: cal_type = p_enr_cal_type AND
1231: ci_sequence_number = p_enr_sequence_number) OR

Line 1272: cp_person_id IGS_AS_SC_ATMPT_ENR.person_id%TYPE,

1268: p_end_month,
1269: sca.commencement_dt) = 'TRUE';
1270:
1271: CURSOR c_scae (
1272: cp_person_id IGS_AS_SC_ATMPT_ENR.person_id%TYPE,
1273: cp_course_cd IGS_AS_SC_ATMPT_ENR.course_cd%TYPE,
1274: cp_start_dt IGS_CA_INST.start_dt%TYPE) IS
1275: SELECT scae.enrolment_cat
1276: FROM IGS_AS_SC_ATMPT_ENR scae,

Line 1273: cp_course_cd IGS_AS_SC_ATMPT_ENR.course_cd%TYPE,

1269: sca.commencement_dt) = 'TRUE';
1270:
1271: CURSOR c_scae (
1272: cp_person_id IGS_AS_SC_ATMPT_ENR.person_id%TYPE,
1273: cp_course_cd IGS_AS_SC_ATMPT_ENR.course_cd%TYPE,
1274: cp_start_dt IGS_CA_INST.start_dt%TYPE) IS
1275: SELECT scae.enrolment_cat
1276: FROM IGS_AS_SC_ATMPT_ENR scae,
1277: IGS_CA_INST ci

Line 1276: FROM IGS_AS_SC_ATMPT_ENR scae,

1272: cp_person_id IGS_AS_SC_ATMPT_ENR.person_id%TYPE,
1273: cp_course_cd IGS_AS_SC_ATMPT_ENR.course_cd%TYPE,
1274: cp_start_dt IGS_CA_INST.start_dt%TYPE) IS
1275: SELECT scae.enrolment_cat
1276: FROM IGS_AS_SC_ATMPT_ENR scae,
1277: IGS_CA_INST ci
1278: WHERE scae.person_id = cp_person_id AND
1279: scae.course_cd = cp_course_cd AND
1280: ci.cal_type = scae.cal_type AND