DBA Data[Home] [Help]

APPS.FV_FACTS_EDIT_CHECK dependencies on FV_FACTS_FEDERAL_ACCOUNTS

Line 2056: FROM fv_facts_temp facts, fv_facts_federal_accounts fffa, fv_treasury_symbols fts

2052:
2053: CURSOR check_18 IS
2054: SELECT nvl(amount,0) amt , sgl_acct_number, transaction_partner,
2055: treasury_dept_code, treasury_acct_code, decode(fffa.non_fed_exc_flag,'Y', 'Allowed','Not Allowed')non_fed_exc_flag_desc
2056: FROM fv_facts_temp facts, fv_facts_federal_accounts fffa, fv_treasury_symbols fts
2057: WHERE facts.treasury_symbol_id = g_treasury_symbol_id
2058: AND facts.treasury_symbol_id = fts.treasury_symbol_id
2059: AND fts.federal_Acct_symbol_id = fffa.federal_Acct_symbol_id
2060: AND ((transaction_partner = 'E'