APPS.IGF_AP_GEN dependencies on IGS_CA_INST_ALL

Line 623: igs_ca_inst_all ca,

619: 11, PRIMARY_ALTERNATE_MONTH_11,
620: 12, PRIMARY_ALTERNATE_MONTH_12 ) ) efc
621: FROM igf_ap_isir_matched_all isir,
622: igf_ap_fa_base_rec_all fa,
623: igs_ca_inst_all ca,
624: igf_aw_coa_itm_terms coa
625: WHERE coa.base_id = fa.base_id
626: AND coa.base_id = isir.base_id
627: AND fa.base_id = cp_base_id

Line 919: FROM igs_ca_inst_all ca,

915: CURSOR c_award_year(
916: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
917: ) IS
918: SELECT ca.alternate_code
919: FROM igs_ca_inst_all ca,
920: igf_ap_fa_base_rec_all fa
921: WHERE fa.base_id = cp_base_id
922: AND fa.ci_cal_type = ca.cal_type
923: AND fa.ci_sequence_number = ca.sequence_number;

Line 924: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;

920: igf_ap_fa_base_rec_all fa
921: WHERE fa.base_id = cp_base_id
922: AND fa.ci_cal_type = ca.cal_type
923: AND fa.ci_sequence_number = ca.sequence_number;
924: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;
925:
926: BEGIN
927: OPEN c_inst(p_base_id,p_item_sequence_number);
928: FETCH c_inst INTO l_inst;