APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSH_NEW_DELIVERIES

Line 7871: from wsh_new_deliveries wds

7867: l_user,
7868: l_user,
7869: sysdate,
7870: sysdate
7871: from wsh_new_deliveries wds
7872: where wds.delivery_id = v_wlji_delivery_id(v_idx)
7873: and not exists (
7874: select 1
7875: from wip_schedule_groups wsg

Line 7884: wsh_new_deliveries wds

7880: wsg.schedule_group_id
7881: into v_wlji_schedule_group_name(v_idx),
7882: v_wlji_schedule_group_id(v_idx)
7883: from wip_schedule_groups wsg,
7884: wsh_new_deliveries wds
7885: where wds.delivery_id = v_wlji_delivery_id(v_idx)
7886: and wsg.schedule_group_name = wds.name
7887: and wsg.organization_id = v_wlji_org_id(v_idx);
7888: end if;