DBA Data[Home] [Help]

APPS.GMD_ROUTINGS_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 266: gmd_recipe_validity_rules vr

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
270: vr.delete_mark = 0;