APPS.IGF_AW_SS_GEN_PKG dependencies on IGS_CA_INST

Line 246: IGS_CA_INST cal

242: cp_award_prd_cd varchar2) IS
243: SELECT apt.ld_cal_type ld_cal_type,
244: apt.ld_sequence_number ld_sequence_number
245: FROM IGF_AW_AWD_PRD_TERM apt,
246: IGS_CA_INST cal
247: WHERE apt.ci_sequence_number = cp_ci_sequence_number
248: AND apt.ci_cal_type = cp_ci_cal_type
249: AND award_prd_cd = cp_award_prd_cd
250: AND apt.ld_cal_type = cal.cal_type

Line 351: IGS_CA_INST cal

347: CURSOR cur_all_terms_awd_prd ( cp_ci_cal_type VARCHAR2, cp_ci_sequence_number NUMBER, cp_award_prd_cd VARCHAR2) IS
348: SELECT apt.ld_cal_type ld_cal_type,
349: apt.ld_sequence_number ld_sequence_number
350: FROM IGF_AW_AWD_PRD_TERM apt,
351: IGS_CA_INST cal
352: WHERE apt.ci_sequence_number = cp_ci_sequence_number
353: AND apt.ci_cal_type = cp_ci_cal_type
354: AND award_prd_cd = cp_award_prd_cd
355: AND apt.ld_cal_type = cal.cal_type