APPS.IGS_SS_ENR_DETAILS dependencies on IGS_EN_CAT_PRC_STEP

Line 2311: FROM igs_en_cat_prc_step

2307: cp_student_comm_type VARCHAR2,
2308: cp_enr_method_type VARCHAR2,
2309: cp_enrolment_step_type VARCHAR2) IS
2310: SELECT 'TRUE'
2311: FROM igs_en_cat_prc_step
2312: WHERE enrolment_cat = cp_enrolment_cat AND
2313: (s_student_comm_type = cp_student_comm_type OR
2314: s_student_comm_type = 'ALL' ) AND
2315: enr_method_type = cp_enr_method_type AND

Line 2318: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;

2314: s_student_comm_type = 'ALL' ) AND
2315: enr_method_type = cp_enr_method_type AND
2316: s_enrolment_step_type = cp_enrolment_step_type;
2317:
2318: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;
2319: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
2320: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
2321: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2322: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 2319: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;

2315: enr_method_type = cp_enr_method_type AND
2316: s_enrolment_step_type = cp_enrolment_step_type;
2317:
2318: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;
2319: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
2320: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
2321: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2322: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2323: l_enrol_cal_type igs_ca_type.cal_type%TYPE;

Line 2320: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;

2316: s_enrolment_step_type = cp_enrolment_step_type;
2317:
2318: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;
2319: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
2320: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
2321: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2322: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2323: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2324: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;