eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_FACTS1_PKG dependencies on FV_FACTS_FEDERAL_ACCOUNTS

Line 691: ln_facts1_rollup fv_facts_federal_accounts.facts1_rollup%TYPE;

687: l_dept_id fv_treasury_symbols.department_id%TYPE;
688: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
689: ln_fund_group_type fv_fund_groups.type%type ;
690: -- CGAC
691: ln_facts1_rollup fv_facts_federal_accounts.facts1_rollup%TYPE;
692: ln_federal_acct_symbol_id fv_treasury_symbols.federal_acct_symbol_id%TYPE;
693:
694: -- Retrieiving federal_acct_symbol_id to use it to obtain facts1_rollup
695: -- from fv_facts_federal_accounts in facts1_rollup_cur cursor

Line 695: -- from fv_facts_federal_accounts in facts1_rollup_cur cursor

691: ln_facts1_rollup fv_facts_federal_accounts.facts1_rollup%TYPE;
692: ln_federal_acct_symbol_id fv_treasury_symbols.federal_acct_symbol_id%TYPE;
693:
694: -- Retrieiving federal_acct_symbol_id to use it to obtain facts1_rollup
695: -- from fv_facts_federal_accounts in facts1_rollup_cur cursor
696: CURSOR fund_cur IS
697: SELECT ffp.fund_value fund_val, fts.fund_group_code fund_grp,
698: fts.department_id dep_id, fts.bureau_id bu_id, fts.federal_acct_symbol_id
699: FROM fv_treasury_symbols fts, fv_fund_parameters ffp

Line 730: FROM fv_facts_federal_accounts

726: -- CGAC
727: DECLARE
728: CURSOR facts1_rollup_cur IS
729: SELECT facts1_rollup
730: FROM fv_facts_federal_accounts
731: WHERE set_of_books_id = gbl_set_of_books_id
732: AND federal_acct_symbol_id = ln_federal_acct_symbol_id;
733: BEGIN
734: ln_facts1_rollup := NULL;