APPS.WIP_WS_UTIL dependencies on WIP_OPERATIONS

Line 581: from wip_operations wo, bom_departments bd

577:
578: if( p_op_seq is not null ) then
579: select bd.department_code
580: into l_dept_code
581: from wip_operations wo, bom_departments bd
582: where wo.department_id = bd.department_id
583: and wo.wip_entity_id = p_wip_entity_id
584: and wo.operation_seq_num = p_op_seq;
585:

Line 900: from wip_operations wo, wip_operation_resources wor

896: l_completion_date := null;
897: else
898: select nvl(wor.department_id, wo.department_id)
899: into l_department_id
900: from wip_operations wo, wip_operation_resources wor
901: where wo.wip_entity_id = p_wip_entity_id
902: and wo.organization_id = p_organization_id
903: and wo.operation_seq_num = p_op_seq_num
904: and wor.wip_entity_id = wo.wip_entity_id