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