62:
63: select SUM(NVL(PERIOD_NET_DR,0)), SUM(NVL(PERIOD_NET_CR,0))
64: into P_PERIOD_NET_DR, P_PERIOD_NET_CR
65: from GL_BALANCES GLB, GL_LEDGERS GLA,
66: GL_PERIOD_STATUSES GLPS,
67: GL_PERIOD_STATUSES GLPSS, GL_PERIOD_STATUSES GLPSE
68: where GLA.LEDGER_ID = P_LEDGER_ID
69: and GLB.LEDGER_ID = P_LEDGER_ID
70: and GLB.CURRENCY_CODE = GLA.CURRENCY_CODE
63: select SUM(NVL(PERIOD_NET_DR,0)), SUM(NVL(PERIOD_NET_CR,0))
64: into P_PERIOD_NET_DR, P_PERIOD_NET_CR
65: from GL_BALANCES GLB, GL_LEDGERS GLA,
66: GL_PERIOD_STATUSES GLPS,
67: GL_PERIOD_STATUSES GLPSS, GL_PERIOD_STATUSES GLPSE
68: where GLA.LEDGER_ID = P_LEDGER_ID
69: and GLB.LEDGER_ID = P_LEDGER_ID
70: and GLB.CURRENCY_CODE = GLA.CURRENCY_CODE
71: and GLB.ACTUAL_FLAG = 'A'