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 3562: from wip_op_resource_instances

3558:
3559: --check if there are any instances attached to the resource
3560: select count(*)
3561: into l_exists
3562: from wip_op_resource_instances
3563: where wip_entity_id = l_wip_entity_id and
3564: operation_seq_num = l_operation_seq_num and
3565: resource_seq_num = l_resource_seq_num;
3566: