APPS.FV_GTAS_GL_PKG dependencies on FV_FACTS_FEDERAL_ACCOUNTS

Line 2437: l_non_fed_exc_flag fv_facts_federal_accounts.non_fed_exc_flag%TYPE;

2433: IS
2434: l_module_name VARCHAR2(200) := g_module_name||'GET_FED_NONFED_CODE';
2435: --l_fund_type fv_treasury_symbols.fund_type%TYPE;
2436: --l_fed_nonfed_code_exists VARCHAR2(1);
2437: l_non_fed_exc_flag fv_facts_federal_accounts.non_fed_exc_flag%TYPE;
2438: --l_dummy NUMBER;
2439: --l_account_type VARCHAR2(1);
2440: l_code_exists VARCHAR2(1);
2441: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;

Line 2584: FROM fv_facts_federal_accounts ffa,

2580: --If nonfederal exception is checked and gtas attribute incldes E return E
2581: --else error
2582: SELECT NVL(ffa.non_fed_exc_flag,'N')
2583: INTO l_non_fed_exc_flag
2584: FROM fv_facts_federal_accounts ffa,
2585: fv_treasury_symbols fts,
2586: fv_fund_parameters ffp
2587: WHERE ffp.set_of_books_id = gbl_sob_id
2588: AND ffp.fund_value = p_fund_value