APPS.IGF_AW_LI_IMPORT dependencies on IGF_AP_ISIR_MATCHED

Line 502: FROM igf_ap_isir_matched_all

498: added to the legacy awards table.
499: ***************************************************************/
500: CURSOR c_get_pay_isir IS
501: SELECT isir_id payment_isir_id
502: FROM igf_ap_isir_matched_all
503: WHERE base_id = g_base_id
504: AND system_record_type = 'ORIGINAL'
505: AND payment_isir = 'Y';
506:

Line 507: l_payment_isir_id igf_ap_isir_matched_all.isir_id%TYPE;

503: WHERE base_id = g_base_id
504: AND system_record_type = 'ORIGINAL'
505: AND payment_isir = 'Y';
506:
507: l_payment_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
508:
509: CURSOR c_get_fund_source IS
510: SELECT fund_source FROM igf_aw_fund_cat_all WHERE fund_code = li_awd_rec.fund_code;
511: l_fund_source igf_aw_fund_cat_all.fund_source%TYPE;

Line 550: igf_ap_isir_matched

546: -- Get the details of transaction number for the base ID and the APP_TRANS_ID present in the interface table.
547: CURSOR c_get_trans_num(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,cp_app_trans_num_txt VARCHAR2) IS
548: SELECT transaction_num
549: FROM
550: igf_ap_isir_matched
551: WHERE
552: BASE_ID=cp_base_id AND
553: transaction_num=cp_app_trans_num_txt;
554: l_trans_num NUMBER;