APPS.EAM_ASSIGN_EMP_PUB dependencies on WIP_OPERATIONS

Line 842: FROM wip_operations wo

838: wo.first_unit_start_date as start_date,
839: wo.last_unit_completion_date as completion_date,
840: ROUND(((wo.last_unit_completion_date - wo.first_unit_start_date)*24),2) as duration,
841: wo.department_id as context_dept_id
842: FROM wip_operations wo
843: WHERE wo.wip_entity_id = p_wip_entity_id
844: AND wo.organization_id = p_organization_id
845: AND wo.operation_seq_num = p_operation_seq_num
846: AND wo.repetitive_schedule_id is null ;

Line 1395: FROM wip_operations wo

1391: AS
1392:
1393: CURSOR l_wo_op_csr_type(p_wip_entity_id IN NUMBER,p_organization_id IN NUMBER) IS
1394: SELECT wo.operation_seq_num
1395: FROM wip_operations wo
1396: WHERE wo.wip_entity_id = p_wip_entity_id
1397: AND wo.organization_id = p_organization_id
1398: AND (wo.disable_date is null OR wo.disable_date > sysdate )
1399: AND wo.repetitive_schedule_id IS NULL;