APPS.IGF_AP_INST_APP dependencies on IGS_CA_TYPE

Line 233: FROM IGS_CA_INST_REL rel, IGS_CA_TYPE typ

229: CURSOR c_all_terms(cp_sup_cal_type igs_ca_inst_all.cal_type%TYPE,
230: cp_sup_seq_number igs_ca_inst_all.sequence_number%TYPE)
231: IS
232: SELECT SUB_CAL_TYPE, SUB_CI_SEQUENCE_NUMBER
233: FROM IGS_CA_INST_REL rel, IGS_CA_TYPE typ
234: WHERE rel.SUP_CAL_TYPE = cp_sup_cal_type
235: AND rel.SUP_CI_SEQUENCE_NUMBER = cp_sup_seq_number
236: AND rel.sub_cal_type=typ.cal_type
237: AND typ.s_cal_cat='LOAD';