APPS.IGS_EN_VAL_ENCMB dependencies on IGS_CA_TYPE

Line 1900: IN (SELECT CAL_TYPE FROM IGS_CA_TYPE WHERE S_CAL_CAT = 'ACADEMIC');

1896: FROM igs_ca_inst_rel
1897: WHERE sub_cal_type = cp_cal_Type
1898: AND sub_ci_sequence_number = cp_cal_seq
1899: AND sup_cal_type
1900: IN (SELECT CAL_TYPE FROM IGS_CA_TYPE WHERE S_CAL_CAT = 'ACADEMIC');
1901:
1902: v_sup_rec sup_cal%ROWTYPE;
1903: l_effective_dt DATE;
1904: BEGIN