[Home] [Help]
154:
155: v_fiscal_yr Varchar2(25) ;
156: v_year_gtn2001 BOOLEAN ;
157: v_time_frame fv_treasury_symbols.time_frame%TYPE ;
158: v_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;
159: v_year_budget_auth VARCHAR2(3);
160:
161:
162: -- ------------------------------------------------------------------
480: Select FFFA.financing_account,
481: FFFA.cohort_segment_name
482: Into vl_financing_acct,
483: v_cohort_seg_name
484: From FV_FACTS_FEDERAL_ACCOUNTS FFFA,
485: FV_TREASURY_SYMBOLS FTS
486: Where FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
487: AND FTS.treasury_symbol = vp_treasury_symbol
488: AND FTS.set_of_books_id = vp_set_of_books_id
1511:
1512: BEGIN
1513: Select FTS.Time_Frame, FFFA.financing_account
1514: INTO v_time_frame, v_financing_acct
1515: From FV_FACTS_FEDERAL_ACCOUNTS FFFA,
1516: FV_TREASURY_SYMBOLS FTS
1517: Where FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
1518: AND FTS.treasury_symbol = vp_treasury_symbol
1519: AND FTS.set_of_books_id = vp_set_of_books_id
1848: RPAD(substr(ffba.borrowing_source,1,6), 6)
1849: Into va_bea_category_val,
1850: va_borrowing_source_val
1851: From fv_facts_budget_accounts ffba,
1852: fv_facts_federal_accounts fffa,
1853: fv_treasury_symbols fts ,
1854: fv_facts_bud_fed_accts ffbfa
1855: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
1856: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id
1896: Begin
1897: Select RPAD(substr(ffba.budget_function,1,3), 3)
1898: Into va_budget_function
1899: From fv_facts_budget_accounts ffba,
1900: fv_facts_federal_accounts fffa,
1901: fv_treasury_symbols fts ,
1902: fv_facts_bud_fed_accts ffbfa
1903: Where fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
1904: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id