DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1514: FROM gme_batch_step_activities

1510:
1511: CURSOR cur_get_activity_factor (v_batchstep_activity_id NUMBER)
1512: IS
1513: SELECT plan_activity_factor, actual_activity_factor
1514: FROM gme_batch_step_activities
1515: WHERE batchstep_activity_id = v_batchstep_activity_id;
1516:
1517: l_resource_qty NUMBER;
1518: l_min_capacity NUMBER;

Line 3535: gme_batch_step_activities to get unique BATCHSTEP_RESOURCE_ID */

3531: FROM gme_batch_steps
3532: WHERE batch_id = l_batch_id AND batchstep_no = l_batchstep_no;
3533:
3534: /* Join of gme_batch_step_resources and
3535: gme_batch_step_activities to get unique BATCHSTEP_RESOURCE_ID */
3536: CURSOR gme_batchstep_resource_id (
3537: l_organization_id IN NUMBER
3538: ,l_batch_id IN NUMBER
3539: ,l_batchstep_id IN NUMBER

Line 3545: ,gme_batch_step_activities gbsa

3541: ,l_resource IN VARCHAR2)
3542: IS
3543: SELECT gbsr.batchstep_resource_id
3544: FROM gme_batch_step_resources gbsr
3545: ,gme_batch_step_activities gbsa
3546: WHERE gbsr.organization_id = l_organization_id
3547: AND gbsr.batch_id = l_batch_id
3548: AND gbsr.batchstep_id = l_batchstep_id
3549: AND gbsa.batch_id = l_batch_id