APPS.GL_AUTOPOST_PKG dependencies on GL_JE_HEADERS

Line 69: GL_JE_HEADERS JEH

65:
66: CURSOR single_ledger (p_posting_run_id NUMBER) IS
67: SELECT max(JEH.ledger_id)
68: FROM GL_JE_BATCHES JEB,
69: GL_JE_HEADERS JEH
70: WHERE JEB.status = 'S'
71: AND JEB.posting_run_id = p_posting_run_id
72: AND JEH.je_batch_id = JEB.je_batch_id
73: GROUP BY JEB.posting_run_id

Line 79: GL_JE_HEADERS JEH

75:
76: CURSOR alc_exists (p_posting_run_id NUMBER) IS
77: SELECT '1'
78: FROM GL_JE_BATCHES JEB,
79: GL_JE_HEADERS JEH
80: WHERE JEB.status = 'S'
81: AND JEB.posting_run_id = p_posting_run_id
82: AND JEH.je_batch_id = JEB.je_batch_id
83: AND JEH.actual_flag <> 'B'

Line 242: GL_JE_HEADERS h,

238: sqlstmt := sqlstmt||'
239: AND b.je_batch_id IN
240: (SELECT h.je_batch_id
241: FROM GL_LEDGERS ledger,
242: GL_JE_HEADERS h,
243: GL_BUDGETS glb,
244: GL_BUDGET_VERSIONS bv,
245: GL_PERIOD_STATUSES ps1,
246: GL_PERIOD_STATUSES ps2

Line 302: FROM GL_JE_HEADERS h

298: add_or := FALSE;
299:
300: sqlstmt := sqlstmt||'
301: AND NOT EXISTS (SELECT 1
302: FROM GL_JE_HEADERS h
303: WHERE h.je_batch_id = b.je_batch_id
304: AND (';
305:
306: IF (X_Je_Category_Name IS NOT NULL) THEN

Line 340: FROM GL_JE_HEADERS glh

336: AND X_Actual_flag = 'A'
337: AND X_Je_Source_Name = 'Manual') THEN
338: sqlstmt := sqlstmt||'
339: AND NOT EXISTS (SELECT 1
340: FROM GL_JE_HEADERS glh
341: WHERE glh.tax_status_code = ''R''
342: AND glh.je_batch_id = b.je_batch_id
343: AND b.actual_flag = ''A''
344: AND glh.currency_code != ''STAT''