DBA Data[Home] [Help]

APPS.WSH_PROCESS_INTERFACED_PKG dependencies on WSH_NEW_DELIVERIES

Line 1117: WSH_NEW_DELIVERIES WND

1113: HZ_CUST_SITE_USES_ALL HCSU,
1114: HZ_CUST_ACCOUNTS HCA,
1115: HZ_PARTY_SITES HPS,
1116: WSH_LOCATIONS WL,
1117: WSH_NEW_DELIVERIES WND
1118: WHERE wnd.delivery_id = p_delivery_id
1119: AND wnd.ultimate_dropoff_location_id = wl.wsh_location_id
1120: AND wl.location_source_code = 'HZ'
1121: AND wl.source_location_id = hps.location_id

Line 1153: FROM wsh_new_deliveries

1149:
1150:
1151: CURSOR dlvy_id_cur(l_del_name VARCHAR2) IS
1152: SELECT delivery_id, ultimate_dropoff_location_id
1153: FROM wsh_new_deliveries
1154: WHERE name=l_del_name;
1155:
1156: -- bug 3920178
1157: CURSOR c_org_oper_unit(p_organization_id IN NUMBER) IS