APPS.GL_JE_BATCHES_PKG dependencies on GL_LEDGERS

Line 111: FROM gl_je_headers jeh, gl_ledgers lgr,

107: CURSOR needs_apprvl IS
108: SELECT 'Needs Approval'
109: FROM dual
110: WHERE EXISTS (SELECT 'Needs Approval'
111: FROM gl_je_headers jeh, gl_ledgers lgr,
112: gl_je_sources src
113: WHERE jeh.je_batch_id = batch_id
114: AND lgr.ledger_id = jeh.ledger_id
115: AND lgr.enable_je_approval_flag = 'Y'

Line 145: FROM gl_je_headers jeh, gl_ledgers lgr

141: CURSOR needstx IS
142: SELECT 'Needs Tax'
143: FROM dual
144: WHERE EXISTS (SELECT 'Needs Tax'
145: FROM gl_je_headers jeh, gl_ledgers lgr
146: WHERE jeh.je_batch_id = batch_id
147: AND jeh.tax_status_code = 'R'
148: AND lgr.ledger_id = jeh.ledger_id
149: AND lgr.enable_automatic_tax_flag = 'Y');

Line 203: GL_JE_HEADERS JH, GL_LEDGERS LGR

199: CURSOR get_ledger_id IS
200: SELECT
201: DISTINCT JH.ledger_id
202: FROM
203: GL_JE_HEADERS JH, GL_LEDGERS LGR
204: WHERE
205: JH.je_batch_id = X_je_batch_id
206: AND (JH.display_alc_journal_flag is null
207: or JH.display_alc_journal_flag = 'Y')