APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_EN_CAT_PRC_DTL

Line 966: FROM igs_en_cat_prc_dtl ecpd, igs_en_cpd_ext ecpe

962: WHERE uoo_id = p_uoo_id;
963:
964: CURSOR cur_min_cp_config IS
965: SELECT ecpd.config_min_cp_valdn, ecpd.enforce_date_alias
966: FROM igs_en_cat_prc_dtl ecpd, igs_en_cpd_ext ecpe
967: WHERE ecpe.s_enrolment_step_type IN ( 'FATD_TYPE' , 'FMIN_CRDT' ) AND
968: ecpe.enrolment_cat = p_enrollment_category AND
969: ecpe.enr_method_type = p_method_type AND
970: (ecpe.s_student_comm_type = p_comm_type

Line 1346: FROM igs_en_cat_prc_dtl ecpd, igs_en_cpd_ext ecpe

1342:
1343: -- Below cursor added as part of Enrl Elgbl and Validation Build. Bug#2616692
1344: CURSOR cur_min_cp_config IS
1345: SELECT ecpd.config_min_cp_valdn, ecpd.enforce_date_alias
1346: FROM igs_en_cat_prc_dtl ecpd, igs_en_cpd_ext ecpe
1347: WHERE ecpe.s_enrolment_step_type IN ( 'FATD_TYPE' , 'FMIN_CRDT' ) AND
1348: ecpe.enrolment_cat = p_enrollment_category AND
1349: ecpe.enr_method_type = p_method_type AND
1350: (ecpe.s_student_comm_type = p_comm_type

Line 1609: CURSOR c_chk_min_cp_valdn( p_enrl_cat igs_en_cat_prc_dtl.enrolment_cat%TYPE,

1605: WHERE sub_cal_type = p_load_cal AND
1606: sub_ci_sequence_number = p_load_ci_sequence_number AND
1607: sup_cal_type = p_acad_cal;
1608:
1609: CURSOR c_chk_min_cp_valdn( p_enrl_cat igs_en_cat_prc_dtl.enrolment_cat%TYPE,
1610: p_enr_meth_type igs_en_method_type.enr_method_type%TYPE,
1611: p_s_stdnt_comm_type VARCHAR2) IS
1612: SELECT notification_flag
1613: FROM igs_en_cpd_ext

Line 1634: l_enrollment_cat igs_en_cat_prc_dtl.enrolment_cat%TYPE;

1630: AND ltt.load_ci_sequence_number = p_load_ci_sequence_number ;
1631:
1632: l_acad_ci_seq_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE;
1633: l_commencement_type VARCHAR2(10);
1634: l_enrollment_cat igs_en_cat_prc_dtl.enrolment_cat%TYPE;
1635: l_enrol_cal_type igs_ca_inst_all.cal_type%TYPE;
1636: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1637: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1638: l_message fnd_new_messages.message_name%TYPE;