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 231: FROM fv_treasury_symbols

227:
228: CURSOR treasury_symbol_range_cur IS
229: SELECT treasury_symbol_id,
230: treasury_symbol
231: FROM fv_treasury_symbols
232: WHERE set_of_books_id = g_set_of_books_id
233: AND Treasury_symbol
234: BETWEEN NVL(p_treasury_symbol_low,treasury_symbol)
235: AND NVL(p_treasury_symbol_high,treasury_symbol)

Line 848: l_time_frame fv_treasury_symbols.time_frame%TYPE ;

844: --l_period_num_high NUMBER(15);
845: l_period_year NUMBER(15);
846: l_cohort_year VARCHAR2(10);
847: l_disbursements_flag VARCHAR2(1);
848: l_time_frame fv_treasury_symbols.time_frame%TYPE ;
849: l_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;
850: l_cohort_select VARCHAR2(100) ;
851: l_cohort VARCHAR2(2) ;
852: l_cohort_num_year NUMBER;

Line 1126: fv_treasury_symbols fts,

1122: ' FROM gl_je_batches gjb,
1123: gl_je_headers gjh,
1124: gl_je_lines gjl,
1125: gl_code_combinations glc,
1126: fv_treasury_symbols fts,
1127: fv_fund_parameters ffp
1128: WHERE gjl.code_combination_id = glc.code_combination_id
1129: AND gjl.ledger_id = :sob_id
1130: AND glc.chart_of_accounts_id= :coa_id

Line 1202: fv_treasury_symbols fts,

1198: ' FROM gl_je_batches gjb,
1199: gl_je_headers gjh,
1200: gl_je_lines gjl,
1201: gl_code_combinations glc,
1202: fv_treasury_symbols fts,
1203: fv_fund_parameters ffp,
1204: xla_ae_lines xal,
1205: xla_ae_headers xah,
1206: xla_distribution_links xdl,

Line 2945: FV_TREASURY_SYMBOLS FTS

2941: BEGIN
2942: SELECT FTS.Time_Frame, fts.financing_account
2943: INTO l_time_frame, l_financing_acct
2944: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,
2945: FV_TREASURY_SYMBOLS FTS
2946: WHERE FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
2947: AND FTS.treasury_symbol_id = g_treasury_symbol_id
2948: AND FTS.set_of_books_id = g_set_of_books_id
2949: AND FFFA.set_of_books_id = g_set_of_books_id ;

Line 4307: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;

4303: --l_fund_fetchn INTEGER;
4304: l_exec_ret INTEGER;
4305: l_row_exists VARCHAR2(1) := NULL;
4306:
4307: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;
4308: l_dept_id fv_treasury_symbols.department_id%TYPE;
4309: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
4310: l_bal_segment VARCHAR2(25);
4311:

Line 4308: l_dept_id fv_treasury_symbols.department_id%TYPE;

4304: l_exec_ret INTEGER;
4305: l_row_exists VARCHAR2(1) := NULL;
4306:
4307: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;
4308: l_dept_id fv_treasury_symbols.department_id%TYPE;
4309: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
4310: l_bal_segment VARCHAR2(25);
4311:
4312: BEGIN

Line 4309: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;

4305: l_row_exists VARCHAR2(1) := NULL;
4306:
4307: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;
4308: l_dept_id fv_treasury_symbols.department_id%TYPE;
4309: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
4310: l_bal_segment VARCHAR2(25);
4311:
4312: BEGIN
4313: l_module_name := g_module_name || 'get_fund_group_info';

Line 4325: 'fv_treasury_symbols fts ' ||

4321: l_fund_select := 'SELECT ''X'', fts.fund_group_code, fts.department_id, ' ||
4322: 'fts.bureau_id, ' ||
4323: 'glc.' || g_bal_segment_name || ' ' ||
4324: 'FROM gl_code_combinations glc, fv_fund_parameters ffp, ' ||
4325: 'fv_treasury_symbols fts ' ||
4326: 'WHERE glc.code_combination_id = :ccid
4327: AND glc.chart_of_accounts_id = :coa_id
4328: AND ffp.treasury_symbol_id = fts.treasury_symbol_id
4329: AND ffp.set_of_books_id = :set_of_books_id

Line 4668: l_cnc fv_treasury_symbols.cust_non_cust%TYPE;

4664: l_fund_category VARCHAR2(1) ;
4665: l_ussgl_enabled VARCHAR2(1) ;
4666: l_reporting_type VARCHAR2(1) ;
4667: l_budget_sub fv_fund_parameters.budget_subfunction %TYPE;
4668: l_cnc fv_treasury_symbols.cust_non_cust%TYPE;
4669: BEGIN
4670: l_module_name := g_module_name || 'load_facts_attributes';
4671: BEGIN
4672: SELECT balance_type,

Line 4740: FROM fv_treasury_symbols fts,

4736: INTO l_resource_type,
4737: g_def_indef_val,
4738: l_fund_category,
4739: g_reimburseable_val
4740: FROM fv_treasury_symbols fts,
4741: fv_fund_parameters ffp
4742: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
4743: AND ffp.fund_value = fund_val
4744: AND fts.treasury_symbol_id = g_treasury_symbol_id

Line 4848: fv_treasury_symbols fts ,

4844:
4845: /* Commented for CGAC
4846: FROM fv_facts_budget_accounts ffba,
4847: fv_facts_federal_accounts fffa,
4848: fv_treasury_symbols fts ,
4849: fv_facts_bud_fed_accts ffbfa
4850: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
4851: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
4852: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id

Line 4893: fv_treasury_symbols fts ,

4889: SELECT RPAD(SUBSTR(ffba.budget_function,1,3), 3)
4890: INTO g_budget_function_val
4891: FROM fv_facts_budget_accounts ffba,
4892: fv_facts_federal_accounts fffa,
4893: fv_treasury_symbols fts ,
4894: fv_facts_bud_fed_accts ffbfa
4895: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
4896: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
4897: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id

Line 4972: FROM fv_treasury_symbols fts, fv_fund_parameters ffp

4968: ----------------------------------------------
4969: IF (g_cust_non_cust_ind = 'Y') THEN
4970: SELECT fts.cust_non_cust
4971: INTO l_cnc
4972: FROM fv_treasury_symbols fts, fv_fund_parameters ffp
4973: WHERE fts.treasury_symbol_id = ffp.treasury_symbol_id
4974: AND ffp.set_of_books_id = g_set_of_books_id
4975: AND ffp.fund_value = fund_val;
4976:

Line 5113: FV_TREASURY_SYMBOLS FTS,

5109: fpfs.cohort_segment_name
5110: INTO l_financing_acct,
5111: g_cohort_seg_name
5112: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,
5113: FV_TREASURY_SYMBOLS FTS,
5114: FV_PYA_FISCALYEAR_SEGMENT fpfs
5115: WHERE FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
5116: AND FTS.treasury_symbol_id = g_treasury_symbol_id
5117: AND FTS.set_of_books_id = g_set_of_books_id