DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEP_ACTIVITIES

Line 439: INSERT INTO gme_batch_step_activities VALUES l_activities_tbl(a);

435: IF (g_debug <= gme_debug.g_log_statement) THEN
436: gme_debug.put_line('After insert steps');
437: END IF;
438: FORALL a IN 1..l_activities_tbl.count
439: INSERT INTO gme_batch_step_activities VALUES l_activities_tbl(a);
440: IF (g_debug <= gme_debug.g_log_statement) THEN
441: gme_debug.put_line('After insert activities');
442: END IF;
443: FORALL a IN 1..l_resources_tbl.count

Line 1807: gme_batch_step_activities a, gme_batch_steps s

1803: SET trans_date = l_date
1804: WHERE trans_date < l_date
1805: AND POC_TRANS_ID IN (select t.POC_TRANS_ID
1806: FROM gme_resource_txns t, gme_batch_step_resources r,
1807: gme_batch_step_activities a, gme_batch_steps s
1808: WHERE s.batch_id = l_batch_header.batch_id
1809: AND t.doc_id = l_batch_header.batch_id
1810: AND s.batchstep_id = l_step_rec.batchstep_id
1811: AND s.batch_id = a.batch_id