APPS.WSH_PO_INTEGRATION_GRP dependencies on WSH_DELIVERY_ASSIGNMENTS_V
Line 448: FROM wsh_delivery_assignments_v wda,wsh_delivery_details wdd
444: ORDER BY NVL(revision_number, -99) DESC;
445: --
446: CURSOR c_GetLastUpdateDates(p_delId NUMBER) IS
447: SELECT MAX(wda.last_update_date), MAX(wdd.last_update_date) 448: FROM wsh_delivery_assignments_v wda,wsh_delivery_details wdd 449: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
450: AND wda.delivery_id = p_delId;
451: --
452: -- This cursor gets the dates for the initial pickup location