APPS.WSMPLBJI dependencies on WSH_NEW_DELIVERIES

Line 5331: from wsh_new_deliveries wds

5327: l_user,
5328: l_user,
5329: sysdate,
5330: sysdate
5331: from wsh_new_deliveries wds
5332: where wds.delivery_id = v_wlji_delivery_id(v_index)
5333: and not exists (
5334: select 1
5335: from wip_schedule_groups wsg

Line 5342: wsh_new_deliveries wds

5338:
5339: select wsg.schedule_group_name, wsg.schedule_group_id
5340: into v_wlji_schedule_group_name(v_index), v_wlji_schedule_group_id(v_index)
5341: from wip_schedule_groups wsg,
5342: wsh_new_deliveries wds
5343: where wds.delivery_id = v_wlji_delivery_id(v_index)
5344: and wsg.schedule_group_name = wds.name
5345: and wsg.organization_id = v_wlji_org(v_index);
5346: end if;