APPS.GL_MANAGEMENT_SEGMENT_UPGRADE dependencies on GL_MGT_SEG_UPGRADE_GT

Line 290: INSERT INTO GL_MGT_SEG_UPGRADE_GT

286: END IF;
287:
288: -- Process posted batches that were recorded as unposted in previous run:
289: -- Move posted batch id to _GT
290: INSERT INTO GL_MGT_SEG_UPGRADE_GT
291: (je_batch_id)
292: SELECT msu.je_batch_id
293: FROM GL_MGT_SEG_UPGRADE MSU,
294: GL_JE_BATCHES B

Line 335: FROM GL_MGT_SEG_UPGRADE_GT GT,

331: 'SEGMENT28', cc.segment28,
332: 'SEGMENT29', cc.segment29,
333: 'SEGMENT30', cc.segment30),
334: sysdate, l_user_id, sysdate, l_user_id, l_login_id
335: FROM GL_MGT_SEG_UPGRADE_GT GT,
336: GL_JE_HEADERS H,
337: GL_JE_LINES L,
338: GL_CODE_COMBINATIONS CC
339: WHERE h.je_batch_id = gt.je_batch_id

Line 379: FROM GL_MGT_SEG_UPGRADE_GT gt);

375: -- Delete from the tracking table the je_batch_id processed
376: DELETE FROM GL_MGT_SEG_UPGRADE MSU
377: WHERE MSU.chart_of_accounts_id = X_Chart_Of_Accounts_Id
378: AND MSU.je_batch_id IN (SELECT gt.je_batch_id
379: FROM GL_MGT_SEG_UPGRADE_GT gt);
380:
381: -- Commit
382: COMMIT;
383: