DBA Data[Home] [Help]

APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_BUDGET_ACCOUNTS

Line 4006: FROM fv_facts_budget_accounts ffba,

4002: where fund_value = fund_val
4003: AND set_of_books_id = vp_set_of_books_id;
4004:
4005: /*
4006: FROM fv_facts_budget_accounts ffba,
4007: fv_facts_federal_accounts fffa,
4008: fv_treasury_symbols fts ,
4009: fv_facts_bud_fed_accts ffbfa
4010: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id

Line 4053: FROM fv_facts_budget_accounts ffba,

4049: BEGIN
4050: -- CGAC: Consider only those treasury symbols whose FACTS_REPORTABLE_INDICATOR is I or II or both
4051: SELECT RPAD(substr(ffba.budget_function,1,3), 3)
4052: INTO va_budget_function
4053: FROM fv_facts_budget_accounts ffba,
4054: fv_facts_federal_accounts fffa,
4055: fv_treasury_symbols fts ,
4056: fv_facts_bud_fed_accts ffbfa
4057: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id