APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGF_AW_AWARD_ALL

Line 799: igf_aw_award_all awd

795:
796: CURSOR cur_fund_id_crd(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
797: SELECT awd.fund_id
798: FROM igf_db_awd_disb_dtl_all disb,
799: igf_aw_award_all awd
800: WHERE awd.award_id = disb.award_id
801: AND disb.sf_credit_id = cp_n_credit_id;
802:
803: CURSOR cur_fund_id_inv(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS

Line 806: igf_aw_award_all awd

802:
803: CURSOR cur_fund_id_inv(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
804: SELECT awd.fund_id
805: FROM igf_db_awd_disb_dtl_all disb,
806: igf_aw_award_all awd
807: WHERE awd.award_id = disb.award_id
808: AND disb.sf_invoice_num = cp_n_invoice_id;
809:
810: CURSOR cur_sys_fund_type(cp_n_fund_id igf_aw_award_all.fund_id%TYPE) IS

Line 810: CURSOR cur_sys_fund_type(cp_n_fund_id igf_aw_award_all.fund_id%TYPE) IS

806: igf_aw_award_all awd
807: WHERE awd.award_id = disb.award_id
808: AND disb.sf_invoice_num = cp_n_invoice_id;
809:
810: CURSOR cur_sys_fund_type(cp_n_fund_id igf_aw_award_all.fund_id%TYPE) IS
811: SELECT fcat.sys_fund_type
812: FROM igf_aw_fund_mast_all fmast,
813: igf_aw_fund_cat_all fcat
814: WHERE fmast.fund_id = cp_n_fund_id

Line 818: l_n_fund_id igf_aw_award_all.fund_id%TYPE;

814: WHERE fmast.fund_id = cp_n_fund_id
815: AND fmast.fund_code = fcat.fund_code;
816:
817: l_v_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
818: l_n_fund_id igf_aw_award_all.fund_id%TYPE;
819:
820: BEGIN
821:
822: -- Fetch the Fund ID from the Disbursements table