DBA Data[Home] [Help]

APPS.GL_JOURNAL_IMPORT_SLA_PKG dependencies on GL_JE_LINES

Line 23: DELETE gl_je_lines

19: AND jeh.je_batch_id = jeb.je_batch_id
20: AND jeh.ledger_id < 0
21: AND jeh.je_source = x_je_source_name);
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

Line 243: UPDATE /*+ INDEX(jel GL_JE_LINES_U1) */

239: END IF;
240: END IF;
241:
242: -- Make the negative ledger ids positive
243: UPDATE /*+ INDEX(jel GL_JE_LINES_U1) */
244: gl_je_lines jel
245: SET jel.ledger_id = -jel.ledger_id
246: WHERE jel.je_header_id IN
247: (SELECT /*+ ORDERED

Line 244: gl_je_lines jel

240: END IF;
241:
242: -- Make the negative ledger ids positive
243: UPDATE /*+ INDEX(jel GL_JE_LINES_U1) */
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)