APPS.IGF_AW_SS_GEN_PKG dependencies on IGF_AW_AWD_PRD_TERM

Line 245: FROM IGF_AW_AWD_PRD_TERM apt,

241: cp_ci_sequence_number number,
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

Line 350: FROM IGF_AW_AWD_PRD_TERM apt,

346: -- Cursor to get the all the terms in an award period
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

Line 453: IGF_AW_AWD_PRD_TERM ap

449: CURSOR c_ap_award (cp_ci_cal_type VARCHAR2, cp_ci_sequence_number NUMBER, cp_award_prd_cd VARCHAR2, cp_base_id NUMBER) IS
450: SELECT awd.*
451: FROM IGF_AW_AWARD_ALL awd,
452: IGF_AW_AWD_DISB_ALL disb,
453: IGF_AW_AWD_PRD_TERM ap
454: WHERE awd.base_id = cp_base_id
455: AND awd.publish_in_ss_flag = 'Y'
456: AND awd.award_id = disb.award_id
457: AND disb.ld_cal_type = ap.ld_cal_type