APPS.GL_JOURNAL_IMPORT_SLA_PKG dependencies on GL_JE_BATCHES

Line 15: FROM gl_je_batches jeb,

11:
12: DELETE gl_import_references
13: WHERE je_header_id IN
14: (SELECT jeh.je_header_id
15: FROM gl_je_batches jeb,
16: gl_je_headers jeh
17: WHERE jeb.status = 'U'
18: AND jeb.group_id = x_group_id
19: AND jeh.je_batch_id = jeb.je_batch_id

Line 26: FROM gl_je_batches jeb,

22:
23: DELETE gl_je_lines
24: WHERE je_header_id IN
25: (SELECT jeh.je_header_id
26: FROM gl_je_batches jeb,
27: gl_je_headers jeh
28: WHERE jeb.status = 'U'
29: AND jeb.group_id = x_group_id
30: AND jeh.je_batch_id = jeb.je_batch_id

Line 39: FROM gl_je_batches jeb

35: WHERE jeh.ledger_id < 0
36: AND jeh.je_source = x_je_source_name
37: AND jeh.je_batch_id IN
38: (SELECT jeb.je_batch_id
39: FROM gl_je_batches jeb
40: WHERE jeb.status = 'U'
41: AND jeb.group_id = x_group_id);
42:
43: DELETE gl_je_batches jeb

Line 43: DELETE gl_je_batches jeb

39: FROM gl_je_batches jeb
40: WHERE jeb.status = 'U'
41: AND jeb.group_id = x_group_id);
42:
43: DELETE gl_je_batches jeb
44: WHERE jeb.status = 'U'
45: AND jeb.group_id = x_group_id
46: AND NOT EXISTS
47: (SELECT 'has journals'

Line 65: FROM GL_JE_BATCHES JEB,

61: found_batch BOOLEAN;
62:
63: CURSOR single_ledger (c_prun_id NUMBER) IS
64: SELECT max(abs(JEH.ledger_id))
65: FROM GL_JE_BATCHES JEB,
66: GL_JE_HEADERS JEH
67: WHERE JEB.status = 'S'
68: AND JEB.posting_run_id = c_prun_id
69: AND JEH.je_batch_id = JEB.je_batch_id

Line 75: FROM GL_JE_BATCHES JEB,

71: HAVING count(distinct abs(JEH.ledger_id)) = 1;
72:
73: CURSOR alc_exists (c_prun_id NUMBER) IS
74: SELECT '1'
75: FROM GL_JE_BATCHES JEB,
76: GL_JE_HEADERS JEH
77: WHERE JEB.status = 'S'
78: AND JEB.posting_run_id = c_prun_id
79: AND JEH.je_batch_id = JEB.je_batch_id

Line 112: UPDATE gl_je_batches jeb

108: SELECT GL_JE_POSTING_S.nextval
109: INTO prun_id
110: FROM dual;
111:
112: UPDATE gl_je_batches jeb
113: SET status = 'S',
114: posting_run_id = prun_id
115: WHERE jeb.status = 'U'
116: AND jeb.group_id = x_group_id

Line 159: FROM gl_je_batches jeb

155: IF (found_batch) THEN
156:
157: SELECT chart_of_accounts_id
158: INTO coa_id
159: FROM gl_je_batches jeb
160: WHERE jeb.status = 'S'
161: AND jeb.posting_run_id = prun_id
162: AND rownum = 1;
163:

Line 229: UPDATE gl_je_batches jeb

225: '', '', '', '', '');
226: END IF;
227:
228: IF (req_id <> 0) THEN
229: UPDATE gl_je_batches jeb
230: SET request_id = req_id
231: WHERE jeb.status = 'S'
232: AND EXISTS
233: (SELECT 'has negative journals'

Line 248: INDEX(jeb GL_JE_BATCHES_N1)

244: gl_je_lines jel
245: SET jel.ledger_id = -jel.ledger_id
246: WHERE jel.je_header_id IN
247: (SELECT /*+ ORDERED
248: INDEX(jeb GL_JE_BATCHES_N1)
249: INDEX(jeh GL_JE_HEADERS_N1)
250: */
251: jeh.je_header_id
252: FROM gl_je_batches jeb,

Line 252: FROM gl_je_batches jeb,

248: INDEX(jeb GL_JE_BATCHES_N1)
249: INDEX(jeh GL_JE_HEADERS_N1)
250: */
251: jeh.je_header_id
252: FROM gl_je_batches jeb,
253: gl_je_headers jeh
254: WHERE jeb.status in ('U','S')
255: AND nvl(jeb.posting_run_id, prun_id) = prun_id
256: AND jeb.group_id = x_group_id

Line 268: FROM gl_je_batches jeb

264: WHERE jeh.ledger_id < 0
265: AND jeh.je_source = x_je_source_name
266: AND jeh.je_batch_id IN
267: (SELECT jeb.je_batch_id
268: FROM gl_je_batches jeb
269: WHERE jeb.status in ('U','S')
270: AND nvl(jeb.posting_run_id, prun_id) = prun_id
271: AND jeb.group_id = x_group_id);
272: