DBA Data[Home] [Help]

APPS.GL_WF_JE_APPROVAL_PKG dependencies on GL_JE_LINES

Line 35: FROM GL_JE_HEADERS jeh, GL_JE_LINES jel, GL_LEDGERS led

31: CURSOR get_ledgers IS
32: SELECT led.ledger_id,
33: max(abs(nvl(jel.accounted_dr, 0) -
34: nvl(jel.accounted_cr, 0))) LARGEST_NET_AMOUNT
35: FROM GL_JE_HEADERS jeh, GL_JE_LINES jel, GL_LEDGERS led
36: WHERE jeh.je_batch_id = p_batch_id
37: AND jeh.currency_code <> 'STAT'
38: AND jel.je_header_id = jeh.je_header_id
39: AND led.ledger_id = jeh.ledger_id

Line 594: FROM GL_JE_HEADERS jeh, GL_JE_LINES jel

590: avalue => l_latest_encumbrance_year );
591:
592: SELECT max(abs(nvl(jel.accounted_dr, 0) - nvl(jel.accounted_cr, 0)))
593: INTO l_ledger_approval_amount
594: FROM GL_JE_HEADERS jeh, GL_JE_LINES jel
595: WHERE jeh.je_batch_id = l_je_batch_id
596: AND jeh.ledger_id = l_ledger_id
597: AND jeh.currency_code <> 'STAT'
598: AND jel.je_header_id = jeh.je_header_id;