eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGF_AW_PACKAGING dependencies on IGF_AP_ISIR_MATCHED

Line 148: || Removed the referrences of the EFC from igf_ap_efc_det table to igf_ap_isir_matched table.

144: || brajendr 10-Dec-2002 Bug # 2701470
145: || Modified the logic for not validating the packaging status for single fund process
146: ||
147: || brajendr 09-Dec-2002 Bug # 2676394
148: || Removed the referrences of the EFC from igf_ap_efc_det table to igf_ap_isir_matched table.
149: || Used igf_aw_packng_subfns.get_fed_efc to calculate the EFC
150: ||
151: || brajendr 07-NOV-2002 Bug # 2613536
152: || Added the code to skip the fund if there are holds for the person

Line 845: || Removed the referrences of the EFC from igf_ap_efc_det table to igf_ap_isir_matched table.

841: || Known limitations, enhancements or remarks :
842: || Change History :
843: || Who When What
844: || brajendr 09-Dec-2002 Bug # 2676394
845: || Removed the referrences of the EFC from igf_ap_efc_det table to igf_ap_isir_matched table.
846: || Used igf_aw_packng_subfns.get_fed_efc to calculate the EFC
847: || (reverse chronological order - newest change first)
848: */
849: l_efc_months NUMBER;

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 8738: l_efc igf_ap_isir_matched.paid_efc%TYPE := 0;

8734: l_match_sum NUMBER(12,2) := 0;
8735: l_est_match_amnt NUMBER(12,2) := 0;
8736: l_efc_cur efc_cur;
8737: l_efc_qry VARCHAR2(1500);
8738: l_efc igf_ap_isir_matched.paid_efc%TYPE := 0;
8739: l_pell_efc igf_ap_isir_matched.paid_efc%TYPE := 0;
8740: l_emulate_fed VARCHAR2(30);
8741: l_inst_method VARCHAR2(30);
8742: l_efc_months NUMBER;

Line 8739: l_pell_efc igf_ap_isir_matched.paid_efc%TYPE := 0;

8735: l_est_match_amnt NUMBER(12,2) := 0;
8736: l_efc_cur efc_cur;
8737: l_efc_qry VARCHAR2(1500);
8738: l_efc igf_ap_isir_matched.paid_efc%TYPE := 0;
8739: l_pell_efc igf_ap_isir_matched.paid_efc%TYPE := 0;
8740: l_emulate_fed VARCHAR2(30);
8741: l_inst_method VARCHAR2(30);
8742: l_efc_months NUMBER;
8743: l_rem_rep_efc NUMBER;

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'