APPS.FV_GTAS_GL_PKG dependencies on FV_TREASURY_SYMBOLS

Line 590: fv_treasury_symbols fts

586: AND period_year = :gbl_period_year) gps,
587: gl_code_combinations glcc,
588: fv_gtas_fed_accounts fgf
589: , fv_fund_parameters ffp,
590: fv_treasury_symbols fts
591: WHERE gjh.period_name = gps.period_name
592: AND gjl.ledger_id = :gbl_sob_id
593: AND gjl.je_header_id = ftt.je_header_id
594: AND gjh.currency_code <> ''STAT''

Line 1371: --l_fund_type fv_treasury_symbols.fund_type%TYPE;

1367: p_reference7 IN VARCHAR2,
1368: p_je_attrib_val IN VARCHAR2,
1369: p_party_info_tab OUT NOCOPY party_info_table) IS
1370: l_module_name VARCHAR2(200) := g_module_name||'GET_TP_ATTRIBUTES';
1371: --l_fund_type fv_treasury_symbols.fund_type%TYPE;
1372: l_tp_type VARCHAR2(1);
1373: --l_tp_id NUMBER;
1374: --l_tp_fed_nonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;
1375: l_tp_name po_vendors.vendor_name%TYPE;

Line 2435: --l_fund_type fv_treasury_symbols.fund_type%TYPE;

2431: p_main_account IN VARCHAR2,
2432: p_fed_nonfed_code OUT NOCOPY VARCHAR2)
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);

Line 2585: fv_treasury_symbols fts,

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
2589: AND ffp.treasury_symbol_id = fts.treasury_symbol_id