APPS.GL_AUTOPOST_PKG dependencies on GL_JE_BATCHES

Line 68: FROM GL_JE_BATCHES JEB,

64: WHERE ledger_id = p_ledger_id;
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

Line 78: FROM GL_JE_BATCHES JEB,

74: HAVING count(distinct JEH.ledger_id) = 1;
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

Line 198: FROM gl_je_batches b

194: b.status,
195: b.default_period_name,
196: b.actual_flag,
197: b.request_id
198: FROM gl_je_batches b
199: WHERE (b.status < ''P'' OR b.status > ''P'')
200: AND b.status_verified = ''N''
201: AND b.budgetary_control_status != ''I''
202: AND greatest(nvl(b.running_total_dr,0),nvl(b.running_total_cr,0)) =

Line 416: UPDATE gl_je_batches

412: END IF;
413:
414: -- Update Batch Status
415: IF (ok_to_update_batch) THEN
416: UPDATE gl_je_batches
417: SET status = 'S',
418: posting_run_id = v_posting_run_id
419: WHERE je_batch_id = v_je_batch_id;
420:

Line 507: FROM gl_je_batches

503: UPDATE GL_CONSOLIDATION_HISTORY
504: SET status = 'PS',
505: request_id = v_request_id
506: WHERE je_batch_id IN (SELECT je_batch_id
507: FROM gl_je_batches
508: WHERE posting_run_id = v_posting_run_id
509: AND status = 'S');
510:
511: UPDATE GL_ELIMINATION_HISTORY EH

Line 515: FROM gl_je_batches

511: UPDATE GL_ELIMINATION_HISTORY EH
512: SET EH.status_code = 'PS',
513: EH.request_id = v_request_id
514: WHERE EH.je_batch_id IN (SELECT je_batch_id
515: FROM gl_je_batches
516: WHERE posting_run_id = v_posting_run_id
517: AND status = 'S');
518:
519: END IF;