APPS.WSH_WSHRDMBL_XMLP_PKG dependencies on WSH_NEW_DELIVERIES

Line 33: WSH_NEW_DELIVERIES WND,

29: INTO L_SHIPPER_NAME
30: FROM
31: WSH_SHIP_FROM_ORGS_V WSFO,
32: WSH_TRIP_STOPS WTS,
33: WSH_NEW_DELIVERIES WND,
34: WSH_DELIVERY_LEGS WDL
35: WHERE WTS.TRIP_ID = P_TRIP_ID
36: AND WTS.STOP_ID = CF_SHIPPER_NAMEFORMULA.STOP_ID
37: AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID

Line 483: WSH_NEW_DELIVERIES

479: SELECT
480: NAME
481: INTO L_PARENT_DEL_NAME
482: FROM
483: WSH_NEW_DELIVERIES
484: WHERE DELIVERY_ID in (
485: SELECT
486: DELIVERY_ID
487: FROM

Line 511: WSH_NEW_DELIVERIES

507: SELECT
508: NAME
509: INTO L_PARENT_DEL_NAME
510: FROM
511: WSH_NEW_DELIVERIES
512: WHERE DELIVERY_ID in (
513: SELECT
514: DELIVERY_ID
515: FROM