APPS.GMD_ROUTING_STEPS_PUB dependencies on GMD_ROUTINGS_B

Line 74: From gmd_routings_b

70:
71: /* Cursor section */
72: CURSOR get_enforce_flag(vRouting_id NUMBER) IS
73: Select enforce_step_dependency
74: From gmd_routings_b
75: Where routing_id = vRouting_id;
76:
77: /* gets the operation no and version associated to the routing detail/Step */
78: Cursor Get_oprn_details(vOprn_id fm_rout_dtl.oprn_id%TYPE) IS

Line 86: From gmd_routings_b

82:
83: /* get routing start date */
84: Cursor get_rout_start_date(vRouting_id NUMBER) IS
85: Select effective_start_date, effective_end_date
86: From gmd_routings_b
87: Where routing_id = vRouting_id;
88:
89: /* Exception section */
90: routing_creation_failure EXCEPTION;

Line 772: From gmd_routings_b

768: Where routingStep_id = vRoutingStep_id;
769:
770: Cursor get_routing_owner_orgn_code(vRouting_id Number) IS
771: Select owner_orgn_code
772: From gmd_routings_b
773: Where routing_id = vRouting_id;
774:
775: /* Define Exceptions */
776: routing_update_step_failure EXCEPTION;