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

Line 11: g_treasury_symbol Fv_Treasury_Symbols.treasury_symbol%TYPE;

7: -- -------------------------------------------------------------
8: g_error_buf VARCHAR2(600);
9: g_error_code NUMBER := 0;
10: g_set_of_books_id NUMBER;
11: g_treasury_symbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
12: g_treasury_symbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;
13: g_period_year Gl_Balances.period_year%TYPE;
14: g_period_num_low Gl_Balances.period_num%TYPE;
15: g_period_num_high Gl_Balances.period_num%TYPE;

Line 12: g_treasury_symbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;

8: g_error_buf VARCHAR2(600);
9: g_error_code NUMBER := 0;
10: g_set_of_books_id NUMBER;
11: g_treasury_symbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
12: g_treasury_symbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;
13: g_period_year Gl_Balances.period_year%TYPE;
14: g_period_num_low Gl_Balances.period_num%TYPE;
15: g_period_num_high Gl_Balances.period_num%TYPE;
16: g_from_period_name Gl_Period_Statuses.period_name%TYPE;

Line 219: FROM fv_treasury_symbols

215:
216: CURSOR treasury_symbol_range_cur IS
217: SELECT treasury_symbol_id,
218: treasury_symbol
219: FROM fv_treasury_symbols
220: WHERE set_of_books_id = g_set_of_books_id
221: AND Treasury_symbol
222: BETWEEN NVL(p_treasury_symbol_low,treasury_symbol)
223: AND NVL(p_treasury_symbol_high,treasury_symbol)

Line 816: l_time_frame fv_treasury_symbols.time_frame%TYPE ;

812: l_period_num_high NUMBER(15);
813: l_period_year NUMBER(15);
814: l_cohort_year VARCHAR2(10);
815: l_disbursements_flag VARCHAR2(1);
816: l_time_frame fv_treasury_symbols.time_frame%TYPE ;
817: l_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;
818: l_cohort_select VARCHAR2(100) ;
819: l_cohort VARCHAR2(2) ;
820: l_cohort_num_year NUMBER;

Line 1083: fv_treasury_symbols fts,

1079: ' FROM gl_je_batches gjb,
1080: gl_je_headers gjh,
1081: gl_je_lines gjl,
1082: gl_code_combinations glc,
1083: fv_treasury_symbols fts,
1084: fv_fund_parameters ffp
1085: WHERE gjl.code_combination_id = glc.code_combination_id
1086: AND gjl.ledger_id = :sob_id
1087: AND glc.chart_of_accounts_id= :coa_id

Line 1158: fv_treasury_symbols fts,

1154: ' FROM gl_je_batches gjb,
1155: gl_je_headers gjh,
1156: gl_je_lines gjl,
1157: gl_code_combinations glc,
1158: fv_treasury_symbols fts,
1159: fv_fund_parameters ffp,
1160: xla_ae_lines xal,
1161: xla_ae_headers xah,
1162: xla_distribution_links xdl,

Line 2783: FV_TREASURY_SYMBOLS FTS

2779: BEGIN
2780: SELECT FTS.Time_Frame, FFFA.financing_account
2781: INTO l_time_frame, l_financing_acct
2782: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,
2783: FV_TREASURY_SYMBOLS FTS
2784: WHERE FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
2785: AND FTS.treasury_symbol_id = g_treasury_symbol_id
2786: AND FTS.set_of_books_id = g_set_of_books_id
2787: AND FFFA.set_of_books_id = g_set_of_books_id ;

Line 4100: 'fv_treasury_symbols fts ' ||

4096: l_fund_select := 'SELECT ''X'', fts.fund_group_code, fts.department_id, ' ||
4097: 'fts.bureau_id, ' ||
4098: 'glc.' || g_bal_segment_name || ' ' ||
4099: 'FROM gl_code_combinations glc, fv_fund_parameters ffp, ' ||
4100: 'fv_treasury_symbols fts ' ||
4101: 'WHERE glc.code_combination_id = :ccid
4102: AND glc.chart_of_accounts_id = :coa_id
4103: AND ffp.treasury_symbol_id = fts.treasury_symbol_id
4104: AND ffp.set_of_books_id = :set_of_books_id

Line 4422: l_cnc fv_treasury_symbols.cust_non_cust%TYPE;

4418: l_fund_category VARCHAR2(1) ;
4419: l_ussgl_enabled VARCHAR2(1) ;
4420: l_reporting_type VARCHAR2(1) ;
4421: l_budget_sub fv_fund_parameters.budget_subfunction %TYPE;
4422: l_cnc fv_treasury_symbols.cust_non_cust%TYPE;
4423: BEGIN
4424: l_module_name := g_module_name || 'load_facts_attributes';
4425: BEGIN
4426: SELECT balance_type,

Line 4490: FROM fv_treasury_symbols fts,

4486: ffp.fund_category
4487: INTO l_resource_type,
4488: g_def_indef_val,
4489: l_fund_category
4490: FROM fv_treasury_symbols fts,
4491: fv_fund_parameters ffp
4492: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
4493: AND ffp.fund_value = fund_val
4494: AND fts.treasury_symbol_id = g_treasury_symbol_id

Line 4580: fv_treasury_symbols fts ,

4576: SELECT RPAD(SUBSTR(ffba.borrowing_source,1,6), 6)
4577: INTO g_borrowing_source_val
4578: FROM fv_facts_budget_accounts ffba,
4579: fv_facts_federal_accounts fffa,
4580: fv_treasury_symbols fts ,
4581: fv_facts_bud_fed_accts ffbfa
4582: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
4583: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
4584: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id

Line 4624: fv_treasury_symbols fts ,

4620: SELECT RPAD(SUBSTR(ffba.budget_function,1,3), 3)
4621: INTO g_budget_function_val
4622: FROM fv_facts_budget_accounts ffba,
4623: fv_facts_federal_accounts fffa,
4624: fv_treasury_symbols fts ,
4625: fv_facts_bud_fed_accts ffbfa
4626: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
4627: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
4628: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id

Line 4695: FROM fv_treasury_symbols fts, fv_fund_parameters ffp

4691: ----------------------------------------------
4692: IF (g_cust_non_cust_ind = 'Y') THEN
4693: SELECT fts.cust_non_cust
4694: INTO l_cnc
4695: FROM fv_treasury_symbols fts, fv_fund_parameters ffp
4696: WHERE fts.treasury_symbol_id = ffp.treasury_symbol_id
4697: AND ffp.set_of_books_id = g_set_of_books_id
4698: AND ffp.fund_value = fund_val;
4699:

Line 4836: FV_TREASURY_SYMBOLS FTS

4832: FFFA.cohort_segment_name
4833: INTO l_financing_acct,
4834: g_cohort_seg_name
4835: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,
4836: FV_TREASURY_SYMBOLS FTS
4837: WHERE FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
4838: AND FTS.treasury_symbol_id = g_treasury_symbol_id
4839: AND FTS.set_of_books_id = g_set_of_books_id
4840: AND FFFA.set_of_books_id = g_set_of_books_id ;