DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1611: FROM gme_batch_step_activities

1607:
1608: CURSOR cur_get_activity_factor (v_batchstep_activity_id NUMBER)
1609: IS
1610: SELECT plan_activity_factor, actual_activity_factor
1611: FROM gme_batch_step_activities
1612: WHERE batchstep_activity_id = v_batchstep_activity_id;
1613:
1614: l_resource_qty NUMBER;
1615: l_min_capacity NUMBER;

Line 3794: gme_batch_step_activities to get unique BATCHSTEP_RESOURCE_ID */

3790: FROM gme_batch_steps
3791: WHERE batch_id = l_batch_id AND batchstep_no = l_batchstep_no;
3792:
3793: /* Join of gme_batch_step_resources and
3794: gme_batch_step_activities to get unique BATCHSTEP_RESOURCE_ID */
3795: CURSOR gme_batchstep_resource_id (
3796: l_organization_id IN NUMBER
3797: ,l_batch_id IN NUMBER
3798: ,l_batchstep_id IN NUMBER

Line 3804: ,gme_batch_step_activities gbsa

3800: ,l_resource IN VARCHAR2)
3801: IS
3802: SELECT gbsr.batchstep_resource_id
3803: FROM gme_batch_step_resources gbsr
3804: ,gme_batch_step_activities gbsa
3805: WHERE gbsr.organization_id = l_organization_id
3806: AND gbsr.batch_id = l_batch_id
3807: AND gbsr.batchstep_id = l_batchstep_id
3808: AND gbsa.batch_id = l_batch_id