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

Line 27: g_treasury_symbol Fv_Treasury_Symbols.treasury_symbol%TYPE;

23: g_PROGRAM_COST_IND Fv_gtas_Attributes.prog_cost_ind1%type;
24: g_exception_category Varchar2(100);
25: g_end_bal_ind fv_gtas_attributes.balance_type%type;
26: --g_fund_value FV_FUND_PARAMETERS.fund_value%TYPE;
27: g_treasury_symbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
28: g_treasury_symbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;
29: g_period_year Gl_Balances.period_year%TYPE;
30: g_period_num_low Gl_Balances.period_num%TYPE;
31: g_period_num_high Gl_Balances.period_num%TYPE;

Line 28: g_treasury_symbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;

24: g_exception_category Varchar2(100);
25: g_end_bal_ind fv_gtas_attributes.balance_type%type;
26: --g_fund_value FV_FUND_PARAMETERS.fund_value%TYPE;
27: g_treasury_symbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
28: g_treasury_symbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;
29: g_period_year Gl_Balances.period_year%TYPE;
30: g_period_num_low Gl_Balances.period_num%TYPE;
31: g_period_num_high Gl_Balances.period_num%TYPE;
32: g_from_period_name Gl_Period_Statuses.period_name%TYPE;

Line 116: g_aid_low fv_treasury_symbols.department_id%TYPE;

112: g_cust_non_cust_val VARCHAR2(1);
113:
114: g_flex_low VARCHAR2(2000);
115: g_flex_high VARCHAR2(2000);
116: g_aid_low fv_treasury_symbols.department_id%TYPE;
117: g_aid_high fv_treasury_symbols.department_id%TYPE;
118: g_main_acct_low fv_treasury_symbols.fund_group_code%TYPE;
119: g_main_acct_high fv_treasury_symbols.fund_group_code%TYPE;
120: g_aid_where varchar2(100);

Line 117: g_aid_high fv_treasury_symbols.department_id%TYPE;

113:
114: g_flex_low VARCHAR2(2000);
115: g_flex_high VARCHAR2(2000);
116: g_aid_low fv_treasury_symbols.department_id%TYPE;
117: g_aid_high fv_treasury_symbols.department_id%TYPE;
118: g_main_acct_low fv_treasury_symbols.fund_group_code%TYPE;
119: g_main_acct_high fv_treasury_symbols.fund_group_code%TYPE;
120: g_aid_where varchar2(100);
121: g_main_acct_where varchar2(100);

Line 118: g_main_acct_low fv_treasury_symbols.fund_group_code%TYPE;

114: g_flex_low VARCHAR2(2000);
115: g_flex_high VARCHAR2(2000);
116: g_aid_low fv_treasury_symbols.department_id%TYPE;
117: g_aid_high fv_treasury_symbols.department_id%TYPE;
118: g_main_acct_low fv_treasury_symbols.fund_group_code%TYPE;
119: g_main_acct_high fv_treasury_symbols.fund_group_code%TYPE;
120: g_aid_where varchar2(100);
121: g_main_acct_where varchar2(100);
122: g_segs_where VARCHAR2(2000);

Line 119: g_main_acct_high fv_treasury_symbols.fund_group_code%TYPE;

115: g_flex_high VARCHAR2(2000);
116: g_aid_low fv_treasury_symbols.department_id%TYPE;
117: g_aid_high fv_treasury_symbols.department_id%TYPE;
118: g_main_acct_low fv_treasury_symbols.fund_group_code%TYPE;
119: g_main_acct_high fv_treasury_symbols.fund_group_code%TYPE;
120: g_aid_where varchar2(100);
121: g_main_acct_where varchar2(100);
122: g_segs_where VARCHAR2(2000);
123: g_src_where VARCHAR2(200);

Line 632: FROM fv_fund_parameters ffp, fv_treasury_symbols fts

628: l_module VARCHAR2(200):= g_module || 'MAIN';
629: /*
630: CURSOR fund_range_cur IS
631: SELECT ffp.fund_value,fts.treasury_symbol_id
632: FROM fv_fund_parameters ffp, fv_treasury_symbols fts
633: WHERE ffp.set_of_books_id = g_set_of_books_id
634: AND fts.set_of_books_id = g_set_of_books_id
635: AND ffp.treasury_symbol_id = fts.treasury_symbol_id
636: --AND fund_value

Line 1154: l_Financing_Account fv_Treasury_symbols.financing_account%type;

1150: l_appor_cat fv_fund_parameters.fund_category%type;
1151: l_c_nc fv_fund_parameters.cust_non_cust%type;
1152: l_bsc fv_fund_parameters.BORROWING_SOURCE_CODE%type;
1153: l_drc fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
1154: l_Financing_Account fv_Treasury_symbols.financing_account%type;
1155: l_cohort_seg_name fv_pya_fiscalyear_segment.cohort_segment_name%type;
1156: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
1157: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
1158: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;

Line 1163: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%type;

1159: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;
1160: select_stmt VARCHAR2(10000);
1161: Vl_Cursor Integer;
1162: I integer;
1163: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%type;
1164: l_Acct_Num Varchar2(20);
1165: BEGIN
1166: log(l_module, 'Begin');
1167:

Line 1385: from fv_treasury_symbols

1381: -- Get Credit Cohort Year only for budgetary accounts
1382: IF get_account_type(l_Acct_Num) IN ('D', 'C') THEN
1383: begin
1384: select Financing_Account into l_Financing_Account
1385: from fv_treasury_symbols
1386: where treasury_symbol_id = l_treasury_symbol_id;
1387:
1388: If l_Financing_Account ='D' Or l_Financing_Account = 'G' Then
1389: SELECT cohort_segment_name

Line 1783: fv_treasury_symbols fts

1779: gl_je_headers gjh,
1780: gl_je_batches gjb,
1781: gl_code_combinations gcc,
1782: fv_fund_parameters ffp,
1783: fv_treasury_symbols fts
1784: WHERE gjl.ledger_id = :sob_id
1785: AND gjl.status = :status
1786: AND gjl.period_name IN
1787: (SELECT period_name

Line 1863: fv_treasury_symbols fts,

1859: gl_je_headers gjh,
1860: gl_je_batches gjb,
1861: gl_code_combinations gcc,
1862: fv_fund_parameters ffp,
1863: fv_treasury_symbols fts,
1864: xla_ae_lines xal,
1865: xla_ae_headers xah,
1866: xla_distribution_links xdl,
1867: gl_import_references gir

Line 4418: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;

4414: --l_fund_fetchn INTEGER;
4415: l_exec_ret INTEGER;
4416: l_row_exists VARCHAR2(1) := NULL;
4417:
4418: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;
4419: l_dept_id fv_treasury_symbols.department_id%TYPE;
4420: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
4421: l_bal_segment VARCHAR2(25);
4422:

Line 4419: l_dept_id fv_treasury_symbols.department_id%TYPE;

4415: l_exec_ret INTEGER;
4416: l_row_exists VARCHAR2(1) := NULL;
4417:
4418: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;
4419: l_dept_id fv_treasury_symbols.department_id%TYPE;
4420: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
4421: l_bal_segment VARCHAR2(25);
4422:
4423: BEGIN

Line 4420: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;

4416: l_row_exists VARCHAR2(1) := NULL;
4417:
4418: l_fund_group fv_treasury_symbols.fund_group_code%TYPE;
4419: l_dept_id fv_treasury_symbols.department_id%TYPE;
4420: l_bureau_id fv_treasury_symbols.bureau_id%TYPE;
4421: l_bal_segment VARCHAR2(25);
4422:
4423: BEGIN
4424:

Line 4436: 'fv_treasury_symbols fts ' ||

4432: 'fts.bureau_id, ' ||
4433: 'glc.' || g_bal_segment_name || ' ' ||
4434: 'FROM gl_code_combinations glc,
4435: fv_fund_parameters ffp, ' ||
4436: 'fv_treasury_symbols fts ' ||
4437: 'WHERE glc.code_combination_id = :ccid
4438: AND glc.chart_of_accounts_id = :coa_id
4439: AND ffp.treasury_symbol_id = fts.treasury_symbol_id
4440: AND ffp.set_of_books_id = :set_of_books_id

Line 4814: FV_TREASURY_SYMBOLS FTS,

4810: fpfs.cohort_segment_name
4811: INTO l_financing_acct,
4812: g_cohort_seg_name
4813: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,
4814: FV_TREASURY_SYMBOLS FTS,
4815: FV_PYA_FISCALYEAR_SEGMENT fpfs
4816: WHERE FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
4817: AND FTS.treasury_symbol_id = g_treasury_symbol_id
4818: AND FTS.set_of_books_id = g_set_of_books_id

Line 5563: fv_treasury_symbols fts,

5559: --else error
5560: SELECT NVL(ffa.non_fed_exc_flag,'N')
5561: INTO l_non_fed_exc_flag
5562: FROM fv_facts_federal_accounts ffa,
5563: fv_treasury_symbols fts,
5564: fv_fund_parameters ffp
5565: WHERE ffp.set_of_books_id = g_set_of_books_id
5566: AND ffp.fund_value = p_fund_value
5567: AND ffp.treasury_symbol_id = fts.treasury_symbol_id