APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on IGS_CA_INST_REL

Line 106: FROM igs_ca_inst_rel r1

102: cp_c_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_n_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE,
103: cp_c_adm_cal_type igs_ca_inst.cal_type%TYPE,cp_n_adm_ci_seq_num igs_ca_inst.sequence_number%TYPE)
104: IS
105: SELECT 'X'
106: FROM igs_ca_inst_rel r1
107: WHERE r1.sub_cal_type = cp_c_load_cal_type AND
108: r1.sub_ci_sequence_number = cp_n_load_ci_seq_num AND
109: r1.sup_cal_type = cp_c_acad_cal_type AND
110: r1.sup_ci_sequence_number = cp_n_acad_ci_seq_num AND

Line 112: FROM igs_ca_inst_rel r2

108: r1.sub_ci_sequence_number = cp_n_load_ci_seq_num AND
109: r1.sup_cal_type = cp_c_acad_cal_type AND
110: r1.sup_ci_sequence_number = cp_n_acad_ci_seq_num AND
111: EXISTS (SELECT 'X'
112: FROM igs_ca_inst_rel r2
113: WHERE r2.sup_cal_type = r1.sup_cal_type AND
114: r2.sup_ci_sequence_number = r1.sup_ci_sequence_number AND
115: r2.sub_cal_type = cp_c_adm_cal_type AND
116: r2.sub_ci_sequence_number = cp_n_adm_ci_seq_num);