APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on IGS_CA_TYPE

Line 596: FROM igs_ca_inst t, igs_ca_type ty

592: CURSOR c_cal_inst (cp_c_cal_type igs_ca_inst.cal_type%TYPE,
593: cp_n_seq_num igs_ca_inst.sequence_number%TYPE)
594: IS
595: SELECT t.cal_type, t.start_dt, t.end_dt
596: FROM igs_ca_inst t, igs_ca_type ty
597: WHERE t.cal_type = ty.cal_type
598: AND ty.s_cal_cat='LOAD'
599: AND t.cal_type = cp_c_cal_type
600: AND t.sequence_number = cp_n_seq_num;