APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_CA_INST_REL

Line 483: l_sub_ci_seq_num IGS_CA_INST_REL.SUB_CI_SEQUENCE_NUMBER%TYPE;

479:
480: l_enr_cal_type IGS_AS_SC_ATMPT_ENR.CAL_TYPE%TYPE;
481: l_enr_seq_num IGS_AS_SC_ATMPT_ENR.CI_SEQUENCE_NUMBER%TYPE;
482: l_enr_category IGS_AS_SC_ATMPT_ENR.ENROLMENT_CAT%TYPE;
483: l_sub_ci_seq_num IGS_CA_INST_REL.SUB_CI_SEQUENCE_NUMBER%TYPE;
484: l_return_value BOOLEAN;
485: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
486:
487: CURSOR c_get_enrolment_cal_type IS

Line 496: CURSOR c_get_cal_rel_dtl_for_enr_cal (c_enr_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE) IS

492: ci.cal_type = scae.cal_type AND
493: ci.sequence_number = scae.ci_sequence_number
494: ORDER BY ci.start_dt DESC;
495:
496: CURSOR c_get_cal_rel_dtl_for_enr_cal (c_enr_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE) IS
497: SELECT cir.sub_ci_sequence_number
498: FROM IGS_CA_INST_REL cir
499: WHERE cir.sup_cal_type = p_acad_cal_type AND
500: cir.sup_ci_sequence_number = p_acad_seq_num AND

Line 498: FROM IGS_CA_INST_REL cir

494: ORDER BY ci.start_dt DESC;
495:
496: CURSOR c_get_cal_rel_dtl_for_enr_cal (c_enr_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE) IS
497: SELECT cir.sub_ci_sequence_number
498: FROM IGS_CA_INST_REL cir
499: WHERE cir.sup_cal_type = p_acad_cal_type AND
500: cir.sup_ci_sequence_number = p_acad_seq_num AND
501: cir.sub_cal_type = c_enr_cal_type;
502: