APPS.IGF_AW_PACKAGING dependencies on IGF_AP_ISIR_MATCHED_ALL

Line 852: l_normal_efc igf_ap_isir_matched_all.paid_efc%TYPE := 0;

848: */
849: l_efc_months NUMBER;
850: lv_rowid ROWID;
851: l_sl_number NUMBER;
852: l_normal_efc igf_ap_isir_matched_all.paid_efc%TYPE := 0;
853: l_pell_efc igf_ap_isir_matched_all.paid_efc%TYPE := 0;
854: l_efc_ay NUMBER := 0;
855: BEGIN
856:

Line 853: l_pell_efc igf_ap_isir_matched_all.paid_efc%TYPE := 0;

849: l_efc_months NUMBER;
850: lv_rowid ROWID;
851: l_sl_number NUMBER;
852: l_normal_efc igf_ap_isir_matched_all.paid_efc%TYPE := 0;
853: l_pell_efc igf_ap_isir_matched_all.paid_efc%TYPE := 0;
854: l_efc_ay NUMBER := 0;
855: BEGIN
856:
857: -- Get the month for which EFC should be calcualted

Line 2308: FROM igf_ap_isir_matched_all

2304: CURSOR c_trans_num(
2305: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
2306: ) IS
2307: SELECT transaction_num
2308: FROM igf_ap_isir_matched_all
2309: WHERE base_id = cp_base_id
2310: AND system_record_type = 'ORIGINAL'
2311: AND payment_isir = 'Y';
2312: l_trans_num c_trans_num%ROWTYPE;

Line 7489: FROM igf_ap_isir_matched_all

7485:
7486: -- Get active isir
7487: CURSOR c_active_isir IS
7488: SELECT isir_id
7489: FROM igf_ap_isir_matched_all
7490: WHERE base_id = p_base_id
7491: AND active_isir = 'Y';
7492: l_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
7493: BEGIN

Line 7492: l_isir_id igf_ap_isir_matched_all.isir_id%TYPE;

7488: SELECT isir_id
7489: FROM igf_ap_isir_matched_all
7490: WHERE base_id = p_base_id
7491: AND active_isir = 'Y';
7492: l_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
7493: BEGIN
7494: l_isir_id := NULL;
7495: OPEN c_active_isir;
7496: FETCH c_active_isir INTO l_isir_id;

Line 13332: igf_ap_isir_matched_all im

13328: cp_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
13329: ) IS
13330: SELECT fabase.base_id,igf_aw_coa_gen.coa_amount(fabase.base_id,g_awd_prd) coa_f
13331: FROM igf_ap_fa_base_rec_all fabase,
13332: igf_ap_isir_matched_all im
13333: WHERE fabase.ci_cal_type = cp_cal_type
13334: AND fabase.ci_sequence_number = cp_sequence_number
13335: AND fabase.target_group IS NOT NULL
13336: AND im.system_record_type = 'ORIGINAL'