DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on WIP_RESOURCE_ACTUAL_TIMES

Line 936: from wip_resource_actual_times wrat

932: -- dbms_output.put_line('units=' || l_units);
933:
934: select count(distinct wrat.instance_id)
935: into l_actual_units
936: from wip_resource_actual_times wrat
937: where wrat.organization_id = p_organization_id
938: and wrat.wip_entity_id = p_wip_entity_id
939: and wrat.operation_seq_num = p_op_seq_num
940: and wrat.resource_seq_num = p_resource_seq_num

Line 1711: from wip_resource_actual_times wrat

1707:
1708: begin
1709: select wrat.start_date
1710: into l_shift_date
1711: from wip_resource_actual_times wrat
1712: where wrat.organization_id = p_org_id
1713: and wrat.employee_id = p_emp_id
1714: and wrat.start_date is not null
1715: and wrat.end_date is null