DBA Data[Home] [Help]

APPS.GL_CALCULATE_TAX_PKG dependencies on GL_JE_BATCHES

Line 55: FROM gl_je_batches jeb

51:
52: -- Lock the batch
53: SELECT 'Good batch'
54: INTO dummy
55: FROM gl_je_batches jeb
56: WHERE jeb.je_batch_id = dummy2
57: FOR UPDATE;
58:
59: -- Get various information

Line 64: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr

60: SELECT jeh.tax_status_code, jeh.ledger_id, jeb.org_id,
61: jeb.default_period_name, lgr.currency_code
62: INTO tax_status_code, lgr_id, org_id, per_name,
63: base_currency
64: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr
65: WHERE jeh.je_header_id = header_id
66: AND jeb.je_batch_id = jeh.je_batch_id
67: AND lgr.ledger_id = jeh.ledger_id;
68: EXCEPTION