APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_CA_INST_REL

Line 1799: FROM igs_ca_inst_rel

1795:
1796: CURSOR c_term_acad_rel(cp_acad IGS_CA_INST.CAL_TYPE%TYPE, cp_term IGS_CA_INST.CAL_TYPE%TYPE,
1797: cp_term_seq IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1798: SELECT 'x'
1799: FROM igs_ca_inst_rel
1800: WHERE sup_cal_type = cp_acad
1801: AND sub_cal_type = cp_term
1802: AND sub_ci_sequence_number = cp_term_seq;
1803:

Line 2333: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

2329: CURSOR c_prim_in_prev_terms(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2330: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2331: cp_cur_term_cal IGS_CA_INST.cal_type%TYPE,
2332: cp_cur_term_seq_num IGS_CA_INST.sequence_number%TYPE,
2333: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2334: cp_transfer_dt IGS_PS_STDNT_TRN.transfer_dt%TYPE ) IS
2335: SELECT 'x'
2336: FROM igs_ca_inst ci2,
2337: igs_ca_inst_rel cir,

Line 2337: igs_ca_inst_rel cir,

2333: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2334: cp_transfer_dt IGS_PS_STDNT_TRN.transfer_dt%TYPE ) IS
2335: SELECT 'x'
2336: FROM igs_ca_inst ci2,
2337: igs_ca_inst_rel cir,
2338: igs_ca_type ct,
2339: igs_ca_inst ci1,
2340: igs_ca_stat cs
2341: WHERE