APPS.FV_FACTS_TBAL_TRX dependencies on FV_FUND_PARAMETERS

Line 31: vp_fund_low fv_fund_parameters.fund_value%type ;

27: vp_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;
28: vp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE ;
29: vp_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE ;
30: vp_summary_type varchar2(1) ;
31: vp_fund_low fv_fund_parameters.fund_value%type ;
32: vp_fund_high fv_fund_parameters.fund_value%type ;
33: vp_period_name gl_period_statuses.period_name%type ;
34: vp_report_id number;
35: vp_output_format varchar2(30);

Line 32: vp_fund_high fv_fund_parameters.fund_value%type ;

28: vp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE ;
29: vp_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE ;
30: vp_summary_type varchar2(1) ;
31: vp_fund_low fv_fund_parameters.fund_value%type ;
32: vp_fund_high fv_fund_parameters.fund_value%type ;
33: vp_period_name gl_period_statuses.period_name%type ;
34: vp_report_id number;
35: vp_output_format varchar2(30);
36: vp_attribute_set varchar2(80);

Line 147: v_tbal_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;

143: v_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;
144: v_year_budget_auth VARCHAR2(3);
145: v_tbal_run_flag Varchar2(1) ;
146: v_tbal_indicator FV_FACTS_TEMP.TBAL_INDICATOR%TYPE ;
147: v_tbal_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;
148: v_tbal_acct_num varchar2(25);
149: v_edit_check_code Number ;
150: -- v_debug varchar2(1) := NVL(FND_PROFILE.VALUE('FV_DEBUG_FLAG'),'N');
151: v_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;

Line 151: v_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;

147: v_tbal_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;
148: v_tbal_acct_num varchar2(25);
149: v_edit_check_code Number ;
150: -- v_debug varchar2(1) := NVL(FND_PROFILE.VALUE('FV_DEBUG_FLAG'),'N');
151: v_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;
152: v_rec_count number(3);
153: vl_pagebreak varchar2(30);
154: v_fund_count number(3);
155: vg_amount NUMBER;

Line 2007: fv_fund_parameters ffp

2003: va_def_indef_val,
2004: vl_fund_category,
2005: va_bea_category_val
2006: From fv_treasury_symbols fts,
2007: fv_fund_parameters ffp
2008: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
2009: AND ffp.fund_value = fund_val
2010: AND fts.treasury_symbol = vp_treasury_symbol
2011: AND fts.set_of_books_id = vp_set_of_books_id

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

2110: -- Deriving BEA Category
2111: --------------------------------------------------------------------
2112: If va_bea_category_flag <> 'Y' then
2113:
2114: /* -- now bea category deived from fv_fund_parameters
2115: Begin
2116: Select RPAD(substr(ffba.bea_category,1,5), 5)
2117: Into va_bea_category_val
2118: from fv_fund_parameters_all

Line 2118: from fv_fund_parameters_all

2114: /* -- now bea category deived from fv_fund_parameters
2115: Begin
2116: Select RPAD(substr(ffba.bea_category,1,5), 5)
2117: Into va_bea_category_val
2118: from fv_fund_parameters_all
2119: where fund_value = vl_fund_value
2120: and set_of_books_id = vp_set_of_books_id;
2121:
2122: From fv_facts_budget_accounts ffba,

Line 3319: From fv_fund_parameters

3315: Select treasury_symbol
3316: Into vp_treasury_symbol
3317: From fv_treasury_symbols
3318: Where treasury_symbol_id = (Select treasury_symbol_id
3319: From fv_fund_parameters
3320: Where fund_value = C_Get_Fund_Values_Rec.flex_value
3321: And set_of_books_id = vp_set_of_books_id);
3322:
3323: -- Getting the treasury_symbol_id