APPS.GMD_ROUTINGS_PVT dependencies on GMD_ROUTINGS_B

Line 251: From gmd_routings_b

247: And steprelease_type <> 1;
248:
249: CURSOR Get_db_last_update_date(vRouting_id gmd_routings.routing_id%TYPE) IS
250: Select last_update_date
251: From gmd_routings_b
252: Where Routing_id = vRouting_id;
253:
254: CURSOR Get_oprn_start_end_dates(vRouting_id NUMBER) IS
255: SELECT max(effective_start_date) effective_start_date

Line 265: From gmd_routings_b rt, gmd_recipes_b rc,

261:
262: CURSOR Get_vr_start_end_dates(vRouting_id NUMBER) IS
263: Select min(vr.Start_Date) Start_Date ,
264: max(NVL(vr.End_Date, trunc(SYSDATE + 999999) ) ) End_Date
265: From gmd_routings_b rt, gmd_recipes_b rc,
266: gmd_recipe_validity_rules vr
267: Where vr.recipe_id = rc.recipe_id AND
268: ((rc.routing_id IS NOT NULL) AND (rc.routing_id = rt.routing_id)) AND
269: rt.routing_id = vRouting_id AND