APPS.IGF_AW_PACKNG_SUBFNS dependencies on IGF_AP_ISIR_MATCHED

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 81: CURSOR c_loan_limit_FFELP ( x_depend_stat igf_ap_isir_matched.dependency_status%TYPE,

77: system_record_type = 'ORIGINAL';
78:
79: l_get_status c_get_status%ROWTYPE;
80:
81: CURSOR c_loan_limit_FFELP ( x_depend_stat igf_ap_isir_matched.dependency_status%TYPE,
82: x_fl_grad_lvl VARCHAR2,
83: x_ci_cal_type Varchar,
84: x_ci_sequence_number Number) IS
85: SELECT subs_annual_lt, tot_annual_lt, subs_aggr_lt, tot_aggr_lt

Line 93: CURSOR c_loan_limit_DL( x_depend_stat igf_ap_isir_matched.dependency_status%TYPE,

89: depend_stat = x_depend_stat AND
90: ffelp_grade_level = x_fl_grad_lvl;
91:
92:
93: CURSOR c_loan_limit_DL( x_depend_stat igf_ap_isir_matched.dependency_status%TYPE,
94: x_ci_cal_type Varchar,
95: x_ci_sequence_number Number,
96: x_dl_grad_lvl VARCHAR2 ) IS
97: SELECT subs_annual_lt, tot_annual_lt, subs_aggr_lt, tot_aggr_lt

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 648: FROM igf_ap_isir_matched

644: CURSOR c_isir_id ( x_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
645: SELECT isir_id,
646: primary_efc,
647: NVL(auto_zero_efc,'N') auto_zero_efc
648: FROM igf_ap_isir_matched
649: WHERE base_id = x_base_id
650: AND active_isir = 'Y';
651:
652: l_isir_id c_isir_id%ROWTYPE;

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 (

Line 716: FROM igf_ap_isir_matched isir

712: 11, isir.primary_alternate_month_11,
713: 12, isir.primary_alternate_month_12
714: )
715: ) efc
716: FROM igf_ap_isir_matched isir
717: WHERE isir.isir_id = cp_isir_id;
718:
719: BEGIN
720: