DBA Data[Home] [Help]

APPS.EAM_OPERATIONS_JSP dependencies on WIP_OP_RESOURCE_INSTANCES

Line 1495: FROM wip_op_resource_instances

1491:
1492: BEGIN
1493:
1494: SELECT 1 INTO l_inst_valid
1495: FROM wip_op_resource_instances
1496: WHERE wip_entity_id = p_wip_entity_id
1497: AND operation_seq_num = p_new_op_seq_num
1498: AND resource_seq_num = p_resource_seq_num
1499: AND instance_id = p_employee_id;

Line 3052: from wip_op_resource_instances

3048:
3049: --check if there are any instances attached to the resource
3050: select count(*)
3051: into l_exists
3052: from wip_op_resource_instances
3053: where wip_entity_id = l_wip_entity_id and
3054: operation_seq_num = l_operation_seq_num and
3055: resource_seq_num = l_resource_seq_num;
3056: