APPS.FV_FACTS_TBAL_TRX dependencies on FV_TREASURY_SYMBOLS

Line 26: vp_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;

22: Commented by 7324248
23: vp_preparer_id Varchar2(8) ;
24: vp_certifier_id Varchar2(8) ;
25: vp_report_qtr number(1);
26: vp_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;
27: vp_summary_type varchar2(1) ;
28: */
29:
30: vp_report_fiscal_yr number(4) ;

Line 33: vp_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE ;

29:
30: vp_report_fiscal_yr number(4) ;
31:
32: vp_currency_code Varchar2(15) ;
33: vp_treasury_symbol fv_treasury_symbols.treasury_symbol%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:

Line 156: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;

152: v_period_cr Number ;
153: v_period_dr Number ;
154: vl_retcode Number ;
155: v_begin_amount number ;
156: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;
157: v_record_category fv_facts_temp.fct_int_record_category%TYPE ;
158: v_fiscal_yr Varchar2(25);
159: v_segment varchar2(30);
160: v_year_gtn2001 BOOLEAN ;

Line 161: v_time_frame fv_treasury_symbols.time_frame%TYPE ;

157: v_record_category fv_facts_temp.fct_int_record_category%TYPE ;
158: v_fiscal_yr Varchar2(25);
159: v_segment varchar2(30);
160: v_year_gtn2001 BOOLEAN ;
161: v_time_frame fv_treasury_symbols.time_frame%TYPE ;
162: v_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;
163: v_year_budget_auth VARCHAR2(3);
164:
165: /*

Line 622: FV_TREASURY_SYMBOLS FTS

618: vl_years_available,
619: vc_dept_transfer
620: From
621: FV_FACTS_FEDERAL_ACCOUNTS FFFA,
622: FV_TREASURY_SYMBOLS FTS
623: Where FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
624: AND (fts.FACTS_REPORTABLE_INDICATOR like 'II' or fts.FACTS_REPORTABLE_INDICATOR like 'I and II')
625: AND FTS.treasury_symbol = vp_treasury_symbol
626: AND FTS.set_of_books_id = vp_set_of_books_id

Line 2136: From fv_treasury_symbols fts,

2132: va_def_indef_val,
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

Line 2251: fv_treasury_symbols fts ,

2247:
2248: From fv_facts_budget_accounts ffba,
2249:
2250: fv_facts_federal_accounts fffa,
2251: fv_treasury_symbols fts ,
2252: fv_facts_bud_fed_accts ffbfa
2253: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
2254: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
2255: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id

Line 2280: fv_treasury_symbols fts ,

2276: Select RPAD(substr(ffba.budget_function,1,3), 3)
2277: Into va_budget_function
2278: From fv_facts_budget_accounts ffba,
2279: fv_facts_federal_accounts fffa,
2280: fv_treasury_symbols fts ,
2281: fv_facts_bud_fed_accts ffbfa
2282: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
2283: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
2284: AND (fts.FACTS_REPORTABLE_INDICATOR like 'II' or fts.FACTS_REPORTABLE_INDICATOR like 'I and II')

Line 2315: fv_treasury_symbols fts ,

2311: /*
2312: Commented for CGAC changes
2313: From fv_facts_budget_accounts ffba,
2314: fv_facts_federal_accounts fffa,
2315: fv_treasury_symbols fts ,
2316: fv_facts_bud_fed_accts ffbfa
2317: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
2318: AND (fts.FACTS_REPORTABLE_INDICATOR like 'II' or fts.FACTS_REPORTABLE_INDICATOR like 'I')
2319: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id

Line 3183: From fv_treasury_symbols

3179: RETURN;
3180: END IF;
3181: Select Treasury_Symbol_id
3182: Into v_treasury_symbol_id
3183: From fv_treasury_symbols
3184: where treasury_symbol = vp_treasury_symbol
3185: AND (FACTS_REPORTABLE_INDICATOR like 'II' or FACTS_REPORTABLE_INDICATOR like 'I and II')
3186: and set_of_books_id = vp_set_of_books_id ;
3187:

Line 3619: From fv_treasury_symbols

3615: BEGIN
3616: --Getting the Treasury Symbol value
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)