APPS.GMDRTVAL_PUB dependencies on GMD_OPERATIONS

Line 314: FROM gmd_operations_b

310: /* Cursor Definitions. */
311: /* =================== */
312: CURSOR Cur_get_oprn IS
313: SELECT oprn_no, oprn_vers, effective_start_date, effective_end_date
314: FROM gmd_operations_b
315: WHERE ((poprn_id IS NOT NULL AND oprn_id = poprn_id)
316: OR (poprn_id IS NULL AND (oprn_no = poprn_no
317: AND oprn_vers = poprn_vers)
318: )

Line 488: FROM gmd_operations o, fm_rout_dtl d

484: X_rout_step_rec Cur_get_routing_steps%ROWTYPE;
485:
486: CURSOR Cur_get_oprn_uom (V_step_no NUMBER) IS
487: SELECT process_qty_uom
488: FROM gmd_operations o, fm_rout_dtl d
489: WHERE d.routing_id = prouting_id
490: AND d.routingstep_no = V_step_no
491: AND d.oprn_id = o.oprn_id;
492:

Line 607: FROM gmd_operations o, fm_rout_dtl d

603: X_rout_step_rec Cur_get_routing_steps%ROWTYPE;
604:
605: CURSOR Cur_get_oprn_uom (V_step_no NUMBER) IS
606: SELECT process_qty_uom
607: FROM gmd_operations o, fm_rout_dtl d
608: WHERE d.routing_id = prouting_id
609: AND d.routingstep_no = V_step_no
610: AND d.oprn_id = o.oprn_id;
611:

Line 744: SELECT count(*) FROM gmd_operations_b

740:
741: l_oprn_count NUMBER := 0;
742:
743: CURSOR check_oprn_count IS
744: SELECT count(*) FROM gmd_operations_b
745: WHERE oprn_id IN (select oprn_id from fm_rout_dtl where routing_id = pRouting_id);
746:
747: BEGIN
748: x_return_status := 'S';