DBA Data[Home] [Help]

APPS.GMP_WPS_WRITER dependencies on GME_BATCH_STEP_ACTIVITIES

Line 339: gme_batch_step_activities gsa

335: gsa.last_update_date,
336: gbs.step_status
337: FROM
338: gme_batch_steps gbs,
339: gme_batch_step_activities gsa
340: WHERE
341: gbs.batchstep_id = v_step_id
342: AND gbs.batchstep_id = gsa.batchstep_id
343: AND gsa.batchstep_activity_id = v_activity_id;

Line 405: gme_batch_step_activities

401: v_start_date := wip_datetimes.float_to_DT(pstart_date/1440+phorizon);
402: v_end_date := wip_datetimes.float_to_DT(pend_date/1440+phorizon);
403:
404: UPDATE
405: gme_batch_step_activities
406: SET
407: plan_start_date = v_start_date,
408: plan_cmplt_date = v_end_date,
409: last_update_date = SYSDATE,

Line 1092: gme_batch_step_activities

1088: CURSOR lock_batch_activities IS
1089: SELECT
1090: batch_id
1091: FROM
1092: gme_batch_step_activities
1093: WHERE
1094: batch_id = v_batch_id
1095: FOR UPDATE NOWAIT;
1096: