APPS.WSH_PROCESS_INTERFACED_PKG dependencies on WSH_NEW_DELIVERIES

Line 1028: WSH_NEW_DELIVERIES WND

1024: HZ_CUST_SITE_USES_ALL HCSU,
1025: HZ_CUST_ACCOUNTS HCA,
1026: HZ_PARTY_SITES HPS,
1027: WSH_LOCATIONS WL,
1028: WSH_NEW_DELIVERIES WND
1029: WHERE wnd.delivery_id = p_delivery_id
1030: AND wnd.ultimate_dropoff_location_id = wl.wsh_location_id
1031: AND wl.location_source_code = 'HZ'
1032: AND wl.source_location_id = hps.location_id

Line 1062: FROM wsh_new_deliveries

1058:
1059:
1060: CURSOR dlvy_id_cur(l_del_name VARCHAR2) IS
1061: SELECT delivery_id
1062: FROM wsh_new_deliveries
1063: WHERE name=l_del_name;
1064:
1065: -- bug 3920178
1066: CURSOR c_org_oper_unit(p_organization_id IN NUMBER) IS