APPS.GL_JOURNAL_IMPORT_SLA_PKG dependencies on GL_JE_HEADERS

Line 16: gl_je_headers jeh

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
20: AND jeh.ledger_id < 0

Line 27: gl_je_headers jeh

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
31: AND jeh.ledger_id < 0

Line 34: DELETE gl_je_headers jeh

30: AND jeh.je_batch_id = jeb.je_batch_id
31: AND jeh.ledger_id < 0
32: AND jeh.je_source = x_je_source_name);
33:
34: DELETE gl_je_headers jeh
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

Line 48: FROM gl_je_headers jeh

44: WHERE jeb.status = 'U'
45: AND jeb.group_id = x_group_id
46: AND NOT EXISTS
47: (SELECT 'has journals'
48: FROM gl_je_headers jeh
49: WHERE jeh.je_batch_id = jeb.je_batch_id);
50: END delete_batches;
51:
52: PROCEDURE keep_batches(x_je_source_name VARCHAR2,

Line 66: GL_JE_HEADERS JEH

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
70: GROUP BY JEB.posting_run_id

Line 76: GL_JE_HEADERS JEH

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
80: AND JEH.actual_flag <> 'B'

Line 120: FROM gl_je_headers jeh,

116: AND jeb.group_id = x_group_id
117: AND jeb.approval_status_code = 'Z'
118: AND NOT EXISTS
119: (SELECT 'not open period'
120: FROM gl_je_headers jeh,
121: gl_ledgers lgr,
122: gl_period_statuses ps
123: WHERE jeh.je_batch_id = jeb.je_batch_id
124: AND lgr.ledger_id = - jeh.ledger_id

Line 145: FROM gl_je_headers jeh

141: between pr.start_period_num
142: and pr.end_period_num)))))
143: AND EXISTS
144: (SELECT 'has negative journals'
145: FROM gl_je_headers jeh
146: WHERE jeh.je_batch_id = jeb.je_batch_id
147: AND jeh.ledger_id < 0
148: AND jeh.je_source = x_je_source_name);
149:

Line 234: FROM gl_je_headers jeh

230: SET request_id = req_id
231: WHERE jeb.status = 'S'
232: AND EXISTS
233: (SELECT 'has negative journals'
234: FROM gl_je_headers jeh
235: WHERE jeh.je_batch_id = jeb.je_batch_id
236: AND jeh.ledger_id < 0
237: AND jeh.je_source = x_je_source_name);
238: END IF;

Line 249: INDEX(jeh GL_JE_HEADERS_N1)

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,
253: gl_je_headers jeh

Line 253: gl_je_headers jeh

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
257: AND jeh.je_batch_id = jeb.je_batch_id

Line 262: UPDATE gl_je_headers jeh

258: AND jeh.ledger_id < 0
259: AND jeh.je_source = x_je_source_name);
260:
261: -- Make the negative ledger ids positive
262: UPDATE gl_je_headers jeh
263: SET jeh.ledger_id = -jeh.ledger_id
264: WHERE jeh.ledger_id < 0
265: AND jeh.je_source = x_je_source_name
266: AND jeh.je_batch_id IN