APPS.IGS_FI_CRDAPI_UTIL dependencies on IGS_CA_TYPE

Line 997: cp_s_cal_cat IN igs_ca_type.s_cal_cat%TYPE)

993: Who When What
994: ********************************************************************************************** */
995: CURSOR c_cal_inst(cp_cal_type IN igs_ca_inst.cal_type%TYPE,
996: cp_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
997: cp_s_cal_cat IN igs_ca_type.s_cal_cat%TYPE)
998: IS
999: SELECT 'x'
1000: FROM igs_ca_inst ci,
1001: igs_ca_type cat,

Line 1001: igs_ca_type cat,

997: cp_s_cal_cat IN igs_ca_type.s_cal_cat%TYPE)
998: IS
999: SELECT 'x'
1000: FROM igs_ca_inst ci,
1001: igs_ca_type cat,
1002: igs_ca_stat stat
1003: WHERE ci.cal_type = cp_cal_type
1004: AND ci.sequence_number = cp_ci_sequence_number
1005: AND ci.cal_status = stat.cal_status