APPS.IGS_PR_CLASS_RANK dependencies on IGS_CA_INST_REL

Line 438: FROM igs_ca_inst_rel

434:
435: CURSOR cur_acad_cal (cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
436: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
437: SELECT sup_cal_type, sup_ci_sequence_number
438: FROM igs_ca_inst_rel
439: WHERE
440: sub_cal_type = cp_cal_type
441: AND sub_ci_sequence_number = cp_ci_sequence_number
442: AND sup_cal_type IN (SELECT CAL_TYPE FROM IGS_CA_TYPE WHERE S_CAL_CAT = 'ACADEMIC') ;