DBA Data[Home] [Help]

APPS.FV_FACTS_EDIT_CHECK dependencies on FV_FACTS_RT7_CODES

Line 518: fv_facts_rt7_codes ffc

514: SELECT ffa.rt7_code_id,
515: ffc.rt7_code,
516: ffa.preclosing_unexpended_amt
517: FROM fv_facts_authorizations ffa,
518: fv_facts_rt7_codes ffc
519: WHERE ffa.treasury_symbol_id = g_treasury_symbol_id
520: AND ffa.rt7_code_id = ffc.rt7_code_id
521: AND ffa.set_of_books_id = p_ledger_id;
522:

Line 988: fv_facts_rt7_codes rtc

984: SELECT NVL(sum(fft.amount),0)
985: INTO l_accounts_balance
986: FROM fv_facts_temp fft,
987: fv_facts_rt7_accounts rta,
988: fv_facts_rt7_codes rtc
989: WHERE rtc.factsII_edit_code = 'Subclass 43'
990: AND rta.rt7_code_id = rtc.rt7_code_id
991: AND rta.rt7_ussgl_account = fft.sgl_acct_number
992: AND fft.treasury_symbol_id = g_treasury_symbol_id