DBA Data[Home] [Help]

APPS.FV_FACTS_EDIT_CHECK dependencies on FV_FACTS_RT7_ACCOUNTS

Line 555: fv_facts_rt7_accounts rta

551:
552: SELECT NVL(sum(fft.amount),0)
553: INTO l_accounts_balance
554: FROM fv_facts_temp fft,
555: fv_facts_rt7_accounts rta
556: WHERE rta.rt7_code_id = l_rt7_code_id
557: AND rta.rt7_ussgl_account = fft.sgl_acct_number
558: AND fft.treasury_symbol_id = g_treasury_symbol_id
559: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 987: fv_facts_rt7_accounts rta,

983: BEGIN
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