APPS.GL_WF_JE_APPROVAL_PKG dependencies on GL_LEDGERS

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 494: recinfo gl_ledgers%ROWTYPE;

490: l_period_set_name VARCHAR2(15);
491: l_budgetary_control_flag VARCHAR2(1);
492: l_enable_automatic_tax_flag VARCHAR2(1);
493: l_latest_encumbrance_year VARCHAR2(15);
494: recinfo gl_ledgers%ROWTYPE;
495:
496: l_ledger_approval_amount NUMBER;
497:
498: CURSOR batch_ledgers (v_batch_id NUMBER, v_curr_ledger_id NUMBER) IS

Line 500: FROM GL_LEDGERS led

496: l_ledger_approval_amount NUMBER;
497:
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

Line 538: GL_LEDGERS_PKG.select_row(recinfo);

534: CLOSE batch_ledgers;
535:
536: -- Retrieve set of books attributes
537: recinfo.ledger_id := l_ledger_id;
538: GL_LEDGERS_PKG.select_row(recinfo);
539:
540: l_func_currency := recinfo.currency_code;
541: l_average_balances_flag := recinfo.enable_average_balances_flag;
542: l_cons_sob_flag := recinfo.consolidation_ledger_flag;

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: