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_FUND_PARAMETERS

Line 26: --g_fund_value FV_FUND_PARAMETERS.fund_value%TYPE;

22: g_CREDIT_COHORT_YR Varchar(25);
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;

Line 298: From Fv_Fund_Parameters

294: cv_sob_id IN NUMBER) IS
295: SELECT fund_value,
296: fund_category,
297: treasury_symbol_id
298: From Fv_Fund_Parameters
299: WHERE fund_value = p_fund_value
300: AND set_of_books_id = p_sob_id;
301:
302: --vl_ts_id NUMBER;

Line 303: vl_fund_value fv_fund_parameters.fund_value%TYPE;

299: WHERE fund_value = p_fund_value
300: AND set_of_books_id = p_sob_id;
301:
302: --vl_ts_id NUMBER;
303: vl_fund_value fv_fund_parameters.fund_value%TYPE;
304: vl_treasury_symbol_id NUMBER;
305: vl_fund_category VARCHAR2(1);
306: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
307: Vl_Prc_Header_Id Number;

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 1148: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;

1144: L_prog_cost_ind1 Fv_gtas_Attributes.prog_cost_ind1%type;
1145: l_prog_cost_ind2 Fv_gtas_Attributes.prog_cost_ind2%type;
1146: l_New_or_Bal_flag Fv_gtas_Attributes.New_or_Bal_flag%type;
1147: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
1148: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
1149: l_Bea_Category fv_fund_parameters.Bea_Category%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;

Line 1149: l_Bea_Category fv_fund_parameters.Bea_Category%type;

1145: l_prog_cost_ind2 Fv_gtas_Attributes.prog_cost_ind2%type;
1146: l_New_or_Bal_flag Fv_gtas_Attributes.New_or_Bal_flag%type;
1147: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
1148: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
1149: l_Bea_Category fv_fund_parameters.Bea_Category%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;

Line 1150: l_appor_cat fv_fund_parameters.fund_category%type;

1146: l_New_or_Bal_flag Fv_gtas_Attributes.New_or_Bal_flag%type;
1147: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
1148: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
1149: l_Bea_Category fv_fund_parameters.Bea_Category%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;

Line 1151: l_c_nc fv_fund_parameters.cust_non_cust%type;

1147: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
1148: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
1149: l_Bea_Category fv_fund_parameters.Bea_Category%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;

Line 1152: l_bsc fv_fund_parameters.BORROWING_SOURCE_CODE%type;

1148: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
1149: l_Bea_Category fv_fund_parameters.Bea_Category%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;

Line 1153: l_drc fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;

1149: l_Bea_Category fv_fund_parameters.Bea_Category%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;

Line 1183: From Fv_Fund_Parameters

1179: into l_treasury_symbol_id,
1180: l_Outlays_Bea_Category_Code, l_Bea_Category,
1181: l_appor_cat,
1182: l_c_nc, l_bsc, l_drc
1183: From Fv_Fund_Parameters
1184: Where Fund_Value =p_fund_val
1185: and set_of_books_id=g_set_of_books_id;
1186:
1187: Exception

Line 1782: fv_fund_parameters ffp,

1778: ' FROM gl_je_lines gjl,
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

Line 1862: fv_fund_parameters ffp,

1858: ' FROM gl_je_lines gjl,
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,

Line 4401: -- balancing segment from the fv_fund_parameters table for the

4397: -- --------------------------------------------------------------------
4398: -- PROCEDURE GET_FUND_GROUP_INFO
4399: -- --------------------------------------------------------------------
4400: -- Its primary purpose get the fund Group, Dept Id, bureau Id and
4401: -- balancing segment from the fv_fund_parameters table for the
4402: -- passed Code Combination Id.
4403: -- --------------------------------------------------------------------
4404: PROCEDURE GET_FUND_GROUP_INFO (p_ccid gl_balances.code_combination_id%TYPE,
4405: p_fund_group IN OUT NOCOPY VARCHAR2,

Line 4435: fv_fund_parameters ffp, ' ||

4431: fts.department_id, ' ||
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

Line 5564: fv_fund_parameters ffp

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
5568: AND fts.federal_acct_symbol_id = ffa.federal_acct_symbol_id;