APPS.FV_FACTS_TBAL_TRX dependencies on FV_FUND_PARAMETERS

Line 38: vp_fund_low fv_fund_parameters.fund_value%type ;

34:
35: vp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE ;
36: vp_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE ;
37:
38: vp_fund_low fv_fund_parameters.fund_value%type ;
39: vp_fund_high fv_fund_parameters.fund_value%type ;
40: vp_period_name gl_period_statuses.period_name%type ;
41: vp_report_id number;
42: vp_output_format varchar2(30);

Line 39: vp_fund_high fv_fund_parameters.fund_value%type ;

35: vp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE ;
36: vp_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE ;
37:
38: vp_fund_low fv_fund_parameters.fund_value%type ;
39: vp_fund_high fv_fund_parameters.fund_value%type ;
40: vp_period_name gl_period_statuses.period_name%type ;
41: vp_report_id number;
42: vp_output_format varchar2(30);
43: vp_attribute_set varchar2(80);

Line 175: v_tbal_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;

171: v_vl_main_cursor_found varchar2(1) := 'N' ;
172: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
173: */
174:
175: v_tbal_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;
176: v_tbal_acct_num varchar2(25);
177:
178: v_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;
179: v_rec_count number(3);

Line 178: v_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;

174:
175: v_tbal_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;
176: v_tbal_acct_num varchar2(25);
177:
178: v_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;
179: v_rec_count number(3);
180: vl_pagebreak varchar2(30);
181: v_fund_count number(3);
182: vg_amount NUMBER;

Line 2137: fv_fund_parameters ffp

2133: vl_fund_category,
2134: va_bea_category_val,
2135: vl_direct_or_reimb_code
2136: From fv_treasury_symbols fts,
2137: fv_fund_parameters ffp
2138: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
2139: AND (fts.FACTS_REPORTABLE_INDICATOR like 'II' or fts.FACTS_REPORTABLE_INDICATOR like 'I and II')
2140: AND ffp.fund_value = fund_val
2141: AND fts.treasury_symbol = vp_treasury_symbol

Line 2240: /* -- now bea category deived from fv_fund_parameters

2236: -- Deriving BEA Category
2237: --------------------------------------------------------------------
2238: If va_bea_category_flag <> 'Y' then
2239:
2240: /* -- now bea category deived from fv_fund_parameters
2241: Begin
2242: Select RPAD(substr(ffba.bea_category,1,5), 5)
2243: Into va_bea_category_val
2244: from fv_fund_parameters_all

Line 2244: from fv_fund_parameters_all

2240: /* -- now bea category deived from fv_fund_parameters
2241: Begin
2242: Select RPAD(substr(ffba.bea_category,1,5), 5)
2243: Into va_bea_category_val
2244: from fv_fund_parameters_all
2245: where fund_value = vl_fund_value
2246: and set_of_books_id = vp_set_of_books_id;
2247:
2248: From fv_facts_budget_accounts ffba,

Line 2306: from fv_fund_parameters

2302: If va_borrowing_source_flag = 'Y' then
2303: Begin
2304: Select RPAD(substr(borrowing_source_code,1,6), 6)
2305: Into va_borrowing_source_val
2306: from fv_fund_parameters
2307: where fund_value = fund_val
2308: and set_of_books_id = vp_set_of_books_id;
2309:
2310:

Line 3621: From fv_fund_parameters

3617: Select treasury_symbol
3618: Into vp_treasury_symbol
3619: From fv_treasury_symbols
3620: Where treasury_symbol_id = (Select treasury_symbol_id
3621: From fv_fund_parameters
3622: Where fund_value = C_Get_Fund_Values_Rec.flex_value
3623: And set_of_books_id = vp_set_of_books_id)
3624: AND (FACTS_REPORTABLE_INDICATOR like 'II' or FACTS_REPORTABLE_INDICATOR like 'I and II');
3625: