APPS.IGS_EN_GEN_006 dependencies on IGS_AS_SC_ATMPT_ENR

Line 41: v_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;

37: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
38: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
39: v_message_name VARCHAR2(30);
40: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
41: v_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
42: CURSOR c_scae_ci IS
43: SELECT scae.cal_type,
44: scae.ci_sequence_number,
45: scae.enrolment_cat

Line 46: FROM IGS_AS_SC_ATMPT_ENR scae,

42: CURSOR c_scae_ci IS
43: SELECT scae.cal_type,
44: scae.ci_sequence_number,
45: scae.enrolment_cat
46: FROM IGS_AS_SC_ATMPT_ENR scae,
47: IGS_CA_INST ci
48: WHERE scae.person_id = p_person_id AND
49: scae.course_cd = p_course_cd AND
50: scae.cal_type = ci.cal_type AND

Line 1217: v_enr_form_due_dt IGS_AS_SC_ATMPT_ENR.enr_form_due_dt%TYPE;

1213: v_course_rqrmnt_complete_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
1214: v_logical_delete_dt IGS_EN_STDNT_PS_ATT.logical_delete_dt%TYPE;
1215: v_cal_type IGS_CA_INST.cal_type%TYPE;
1216: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1217: v_enr_form_due_dt IGS_AS_SC_ATMPT_ENR.enr_form_due_dt%TYPE;
1218: v_exists_flag VARCHAR2(1);
1219: CURSOR c_sca IS
1220: SELECT sca.course_attempt_status,
1221: sca.student_confirmed_ind,

Line 1268: FROM IGS_AS_SC_ATMPT_ENR scae,

1264: CURSOR c_scae IS
1265: SELECT ci.cal_type,
1266: scae.ci_sequence_number,
1267: scae.enr_form_due_dt
1268: FROM IGS_AS_SC_ATMPT_ENR scae,
1269: IGS_CA_INST ci
1270: WHERE scae.person_id = p_person_id AND
1271: scae.course_cd = p_course_cd AND
1272: ci.cal_type = scae.cal_type AND