DBA Data[Home] [Help]

APPS.FV_FACTS_TBAL_TRX dependencies on FV_FACTS_BUD_FED_ACCTS

Line 2252: fv_facts_bud_fed_accts ffbfa

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

Line 2281: fv_facts_bud_fed_accts ffbfa

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

Line 2316: fv_facts_bud_fed_accts ffbfa

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