APPS.EAM_SKILL_INSTANCE dependencies on WIP_OPERATION_RESOURCES

Line 35: from wip_operation_resources wor

31:
32:
33: if (p_start_date is null) or (p_completion_date is null) or (p_organization_id is null) then
34: select distinct start_date, completion_date, organization_id into l_start_date, l_completion_date, l_org_id
35: from wip_operation_resources wor
36: where wor.wip_entity_id = p_wip_entity_id
37: and wor.operation_seq_num = p_operation_seq_num
38: and wor.resource_seq_num = p_resource_seq_num;
39: end if;

Line 158: from WIP_OPERATION_RESOURCES

154: operation_seq_num = p_operation_seq_num and
155: resource_seq_num = p_resource_seq_num;
156:
157: select nvl(assigned_units,0) into l_assigned_units_num
158: from WIP_OPERATION_RESOURCES
159: where wip_entity_id = p_wip_entity_id and
160: operation_seq_num = p_operation_seq_num and
161: resource_seq_num = p_resource_seq_num;
162:

Line 168: update wip_operation_resources

164: --if assigned units are less then increment
165:
166: if( l_instance_num + 1 > l_assigned_units_num ) then
167: p_assigned_changed := 1;
168: update wip_operation_resources
169: set assigned_units = (l_instance_num + 1)
170: where wip_entity_id = p_wip_entity_id and
171: operation_seq_num = p_operation_seq_num and
172: resource_seq_num = p_resource_seq_num;