APPS.WSMPLBJI dependencies on WSH_NEW_DELIVERIES

Line 5325: from wsh_new_deliveries wds

5321: l_user,
5322: l_user,
5323: sysdate,
5324: sysdate
5325: from wsh_new_deliveries wds
5326: where wds.delivery_id = v_wlji_delivery_id(v_index)
5327: and not exists (
5328: select 1
5329: from wip_schedule_groups wsg

Line 5336: wsh_new_deliveries wds

5332:
5333: select wsg.schedule_group_name, wsg.schedule_group_id
5334: into v_wlji_schedule_group_name(v_index), v_wlji_schedule_group_id(v_index)
5335: from wip_schedule_groups wsg,
5336: wsh_new_deliveries wds
5337: where wds.delivery_id = v_wlji_delivery_id(v_index)
5338: and wsg.schedule_group_name = wds.name
5339: and wsg.organization_id = v_wlji_org(v_index);
5340: end if;