DBA Data[Home] [Help]

APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGF_AW_FUND_MAST_ALL

Line 812: FROM igf_aw_fund_mast_all fmast,

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
815: AND fmast.fund_code = fcat.fund_code;
816:

Line 1413: FROM igf_aw_fund_mast_all fmast,

1409:
1410: CURSOR cur_chk_spn(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1411: cp_v_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE) IS
1412: SELECT 'x'
1413: FROM igf_aw_fund_mast_all fmast,
1414: igf_aw_fund_cat_all fcat
1415: WHERE fmast.fund_code = fcat.fund_code
1416: AND fcat.sys_fund_type = cp_v_sys_fund_type
1417: AND fmast.party_id = cp_n_person_id;