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_TRX dependencies on FV_FACTS_FEDERAL_ACCOUNTS

Line 162: v_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;

158: v_fiscal_yr Varchar2(25);
159: v_segment varchar2(30);
160: v_year_gtn2001 BOOLEAN ;
161: v_time_frame fv_treasury_symbols.time_frame%TYPE ;
162: v_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;
163: v_year_budget_auth VARCHAR2(3);
164:
165: /*
166: Commented as not used

Line 621: FV_FACTS_FEDERAL_ACCOUNTS FFFA,

617: vc_acct_split_seq_num,
618: vl_years_available,
619: vc_dept_transfer
620: From
621: FV_FACTS_FEDERAL_ACCOUNTS FFFA,
622: FV_TREASURY_SYMBOLS FTS
623: Where FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
624: AND (fts.FACTS_REPORTABLE_INDICATOR like 'II' or fts.FACTS_REPORTABLE_INDICATOR like 'I and II')
625: AND FTS.treasury_symbol = vp_treasury_symbol

Line 2250: fv_facts_federal_accounts fffa,

2246: and set_of_books_id = vp_set_of_books_id;
2247:
2248: From fv_facts_budget_accounts ffba,
2249:
2250: fv_facts_federal_accounts fffa,
2251: fv_treasury_symbols fts ,
2252: fv_facts_bud_fed_accts ffbfa
2253: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
2254: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id

Line 2279: fv_facts_federal_accounts fffa,

2275: Begin
2276: Select RPAD(substr(ffba.budget_function,1,3), 3)
2277: Into va_budget_function
2278: From fv_facts_budget_accounts ffba,
2279: fv_facts_federal_accounts fffa,
2280: fv_treasury_symbols fts ,
2281: fv_facts_bud_fed_accts ffbfa
2282: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
2283: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id

Line 2314: fv_facts_federal_accounts fffa,

2310:
2311: /*
2312: Commented for CGAC changes
2313: From fv_facts_budget_accounts ffba,
2314: fv_facts_federal_accounts fffa,
2315: fv_treasury_symbols fts ,
2316: fv_facts_bud_fed_accts ffbfa
2317: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
2318: AND (fts.FACTS_REPORTABLE_INDICATOR like 'II' or fts.FACTS_REPORTABLE_INDICATOR like 'I')