DBA Data[Home] [Help]

APPS.FV_GTAS_GL_PKG dependencies on FV_FUND_PARAMETERS

Line 406: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;

402: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
403: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
404: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
405: TYPE je_attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
406: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;
407: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;
408: TYPE party_id_t IS TABLE OF fv_gtas_activity_balances.trading_partner_id%TYPE;
409: TYPE party_type_t IS TABLE OF fv_gtas_activity_balances.trading_partner_type%TYPE;
410: TYPE party_name_t IS TABLE OF fv_gtas_activity_balances.trading_partner_name%TYPE;

Line 589: , fv_fund_parameters ffp,

585: AND period_num BETWEEN :gbl_period_num_low AND :gbl_period_num_high
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

Line 2586: fv_fund_parameters ffp

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
2590: AND fts.federal_acct_symbol_id = ffa.federal_acct_symbol_id;