787:
788: SELECT SUM(NVL(accounted_dr,0) - NVL(accounted_cr,0))
789: INTO l_amount
790: FROM Gl_bc_packets gbc,
791: gl_account_hierarchies gah
792: WHERE gbc.ledger_id = p_Ledger_id
793: AND gah.ledger_id = p_Ledger_id
794: AND gah.template_id = l_template_id
795: AND gah.summary_code_combination_id = l_ccid