DBA Data[Home] [Help]

APPS.GL_BALANCES_PKG dependencies on GL_PERIOD_STATUSES

Line 66: GL_PERIOD_STATUSES GLPS,

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

Line 67: GL_PERIOD_STATUSES GLPSS, GL_PERIOD_STATUSES GLPSE

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'