APPS.IGF_AW_PACKNG_SUBFNS dependencies on IGF_AP_ISIR_MATCHED_ALL

Line 74: FROM igf_ap_isir_matched_all

70: l_fabase_det c_fabase_det%ROWTYPE;
71:
72: CURSOR c_get_status IS
73: SELECT dependency_status
74: FROM igf_ap_isir_matched_all
75: WHERE base_id = l_base_id AND
76: payment_isir = 'Y' AND
77: system_record_type = 'ORIGINAL';
78:

Line 112: FROM igf_ap_isir_matched_all isir,igf_ap_nslds_data nslds

108: CURSOR c_nslds_loans IS SELECT
109: NVL(nslds.nslds_agg_subsz_out_prin_bal,0) aggr_subs_loan,
110: NVL(nslds.nslds_agg_comb_out_prin_bal,0) aggr_total_loan,
111: isir.tran_process_date
112: FROM igf_ap_isir_matched_all isir,igf_ap_nslds_data nslds
113: WHERE nslds.base_id = l_base_id
114: AND isir.isir_id = nslds.isir_id
115: ORDER BY TO_NUMBER(nslds.transaction_num_txt) DESC;
116:

Line 657: igf_ap_isir_matched_all isir

653:
654: CURSOR c_pell_efc ( cp_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
655: SELECT DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) pell_efc
656: FROM igf_ap_fa_base_rec_all fa,
657: igf_ap_isir_matched_all isir
658: WHERE fa.base_id = isir.base_id
659: AND fa.base_id = cp_base_id
660: AND isir.active_isir = 'Y';
661:

Line 679: cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE,

675:
676: l_coa_months NUMBER;
677:
678: CURSOR c_efc(
679: cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
680: cp_months_num NUMBER,
681: cp_awd_fmly_contrib_type igf_ap_fa_base_rec_all.award_fmly_contribution_type%TYPE
682: ) IS
683: SELECT DECODE (