DBA Data[Home] [Help]

APPS.GLXJEENT_PKG dependencies on GL_JE_HEADERS

Line 220: FROM gl_je_headers

216: (SELECT 'not latest'
217: FROM gl_period_statuses ps1, gl_period_statuses ps2
218: WHERE ps1.application_id = 101
219: AND ps1.ledger_id IN (SELECT ledger_id
220: FROM gl_je_headers
221: WHERE je_batch_id = x_arg_id)
222: AND ps1.period_name = x_period_name
223: AND ps2.application_id = 101
224: AND ps2.ledger_id = ps1.ledger_id

Line 281: FROM gl_je_headers jeh,

277: WHERE period_set_name = x_period_set_name
278: AND period_type = x_period_type
279: AND NOT EXISTS
280: (SELECT 'unopened ledger'
281: FROM gl_je_headers jeh,
282: gl_period_statuses ps
283: WHERE jeh.je_batch_id = x_je_batch_id
284: AND (jeh.display_alc_journal_flag IS NULL
285: or jeh.display_alc_journal_flag = 'Y')

Line 299: FROM gl_je_headers jeh,

295: WHERE period_set_name = x_period_set_name
296: AND period_type = x_period_type
297: AND NOT EXISTS
298: (SELECT 'unopened ledger'
299: FROM gl_je_headers jeh,
300: gl_period_statuses ps
301: WHERE jeh.je_batch_id = x_je_batch_id
302: AND (jeh.display_alc_journal_flag IS NULL
303: or jeh.display_alc_journal_flag = 'Y')