APPS.GL_WF_JE_APPROVAL_PKG dependencies on GL_JE_HEADERS

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 502: FROM GL_JE_HEADERS jeh

498: CURSOR batch_ledgers (v_batch_id NUMBER, v_curr_ledger_id NUMBER) IS
499: SELECT led.ledger_id
500: FROM GL_LEDGERS led
501: WHERE led.ledger_id IN (SELECT jeh.ledger_id
502: FROM GL_JE_HEADERS jeh
503: WHERE jeh.je_batch_id = v_batch_id)
504: AND led.ledger_id > v_curr_ledger_id
505: ORDER BY led.ledger_id;
506:

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;

Line 770: FROM GL_JE_HEADERS JEH, GL_LEDGERS LED

766: SELECT 'untaxed journals'
767: FROM DUAL
768: WHERE EXISTS
769: (SELECT 'UNTAXED'
770: FROM GL_JE_HEADERS JEH, GL_LEDGERS LED
771: WHERE JEH.je_batch_id = l_je_batch_id
772: AND JEH.tax_status_code = 'R'
773: AND JEH.currency_code <> 'STAT'
774: AND JEH.je_source = 'Manual'

Line 841: FROM GL_JE_HEADERS jeh, GL_LEDGERS led

837:
838: -- Check if budgetary control is on but funds have not been reserved.
839: SELECT nvl(max(led.enable_budgetary_control_flag), 'N')
840: INTO l_budgetary_control_flag
841: FROM GL_JE_HEADERS jeh, GL_LEDGERS led
842: WHERE jeh.je_batch_id = l_je_batch_id
843: AND led.ledger_id = jeh.ledger_id
844: AND led.enable_budgetary_control_flag = 'Y';
845:

Line 946: FROM GL_JE_HEADERS

942: SELECT 'non stat journal exists'
943: FROM DUAL
944: WHERE EXISTS
945: (SELECT 'X'
946: FROM GL_JE_HEADERS
947: WHERE je_batch_id = l_je_batch_id
948: AND currency_code <> 'STAT');
949: BEGIN
950: IF ( funcmode = 'RUN' ) THEN