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_FACTS_TBAL_TRANSACTIONS dependencies on FV_TREASURY_SYMBOLS

Line 157: v_time_frame fv_treasury_symbols.time_frame%TYPE ;

153: v_debug Boolean := TRUE ;
154:
155: v_fiscal_yr Varchar2(25) ;
156: v_year_gtn2001 BOOLEAN ;
157: v_time_frame fv_treasury_symbols.time_frame%TYPE ;
158: v_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;
159: v_year_budget_auth VARCHAR2(3);
160:
161:

Line 226: From fv_treasury_symbols

222: Begin --TS
223:
224: Select Treasury_Symbol_id
225: Into v_treasury_symbol_id
226: From fv_treasury_symbols
227: where treasury_symbol = vp_treasury_symbol
228: And set_of_books_id = vp_set_of_books_id;
229:
230:

Line 485: FV_TREASURY_SYMBOLS FTS

481: FFFA.cohort_segment_name
482: Into vl_financing_acct,
483: v_cohort_seg_name
484: From FV_FACTS_FEDERAL_ACCOUNTS FFFA,
485: FV_TREASURY_SYMBOLS FTS
486: Where FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
487: AND FTS.treasury_symbol = vp_treasury_symbol
488: AND FTS.set_of_books_id = vp_set_of_books_id
489: AND FFFA.set_of_books_id = vp_set_of_books_id ;

Line 694: FV_TREASURY_SYMBOLS FTS

690: vl_main_select := 'SELECT DISTINCT GLCC.'||v_acc_seg_name||
691: ', GLCC.'||v_bal_seg_name||v_cohort_select||
692: ' FROM GL_CODE_COMBINATIONS GLCC,
693: FV_FUND_PARAMETERS FFP,
694: FV_TREASURY_SYMBOLS FTS
695: WHERE FTS.TREASURY_SYMBOL = ' ||''''||vp_treasury_symbol||'''' ||
696: --pkpatel :changed to fix Bug 1575992
697: ' AND FTS.TREASURY_SYMBOL_ID = FFP.TREASURY_SYMBOL_ID
698: AND GLCC.'|| v_bal_seg_name ||'= FFP.FUND_VALUE

Line 1516: FV_TREASURY_SYMBOLS FTS

1512: BEGIN
1513: Select FTS.Time_Frame, FFFA.financing_account
1514: INTO v_time_frame, v_financing_acct
1515: From FV_FACTS_FEDERAL_ACCOUNTS FFFA,
1516: FV_TREASURY_SYMBOLS FTS
1517: Where FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
1518: AND FTS.treasury_symbol = vp_treasury_symbol
1519: AND FTS.set_of_books_id = vp_set_of_books_id
1520: AND FFFA.set_of_books_id = vp_set_of_books_id ;

Line 1748: From fv_treasury_symbols fts,

1744: ffp.fund_category
1745: INTO vl_resource_type,
1746: va_def_indef_val,
1747: vl_fund_category
1748: From fv_treasury_symbols fts,
1749: fv_fund_parameters ffp
1750: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
1751: AND ffp.fund_value = fund_val
1752: AND fts.treasury_symbol = vp_treasury_symbol

Line 1853: fv_treasury_symbols fts ,

1849: Into va_bea_category_val,
1850: va_borrowing_source_val
1851: From fv_facts_budget_accounts ffba,
1852: fv_facts_federal_accounts fffa,
1853: fv_treasury_symbols fts ,
1854: fv_facts_bud_fed_accts ffbfa
1855: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
1856: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
1857: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id

Line 1901: fv_treasury_symbols fts ,

1897: Select RPAD(substr(ffba.budget_function,1,3), 3)
1898: Into va_budget_function
1899: From fv_facts_budget_accounts ffba,
1900: fv_facts_federal_accounts fffa,
1901: fv_treasury_symbols fts ,
1902: fv_facts_bud_fed_accts ffbfa
1903: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
1904: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
1905: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id