APPS.WIP_WS_UTIL dependencies on WIP_WS_RES_SHORTAGE

Line 1450: from wip_ws_res_shortage

1446: /* Bug 9221212 , remove rownum =1 as we should consider the resource_shortage
1447: for all resources not only the first resource*/
1448: select decode(nvl(sum(RESOURCE_SHORTAGE),-1),-1,3,0,2,1)
1449: into l_res_shortage
1450: from wip_ws_res_shortage
1451: where wip_entity_id = p_wip_entity_id
1452: and organization_id = p_org_id;
1453:
1454: --l_res_shortage :=1;