APPS.WSH_FTE_COMP_CONSTRAINT_GRP dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 380: FROM wsh_delivery_assignments wda

376:
377: CURSOR c_get_consol_dlvy(c_delivery_id IN NUMBER) IS
378: SELECT
379: wda.parent_delivery_id
380: FROM wsh_delivery_assignments wda
381: WHERE wda.delivery_id = c_delivery_id
382: AND TYPE= 'C';
383:
384: CURSOR c_get_dlvy_trip_id(c_delivery_id IN NUMBER) IS