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
2256: AND fts.treasury_symbol = vp_treasury_symbol
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')
2285: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id
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
2320: AND ffbfa.budget_acct_code_id = ffba.budget_acct_code_id