APPS.WIP_WS_UTIL dependencies on WIP_OPERATIONS

Line 540: from wip_operations wo, bom_departments bd

536:
537: if( p_op_seq is not null ) then
538: select bd.department_code
539: into l_dept_code
540: from wip_operations wo, bom_departments bd
541: where wo.department_id = bd.department_id
542: and wo.wip_entity_id = p_wip_entity_id
543: and wo.operation_seq_num = p_op_seq;
544:

Line 859: from wip_operations wo, wip_operation_resources wor

855: l_completion_date := null;
856: else
857: select nvl(wor.department_id, wo.department_id)
858: into l_department_id
859: from wip_operations wo, wip_operation_resources wor
860: where wo.wip_entity_id = p_wip_entity_id
861: and wo.organization_id = p_organization_id
862: and wo.operation_seq_num = p_op_seq_num
863: and wor.wip_entity_id = wo.wip_entity_id