APPS.EAM_OP_VALIDATE_PVT dependencies on WIP_OPERATION_RESOURCES

Line 191: from wip_operation_resources

187: select count(*)
188: into l_res_count
189: from dual
190: where exists (select 1
191: from wip_operation_resources
192: where wip_entity_id = p_wip_entity_id
193: and organization_id = p_organization_id
194: and operation_seq_num = p_operation_seq_num);
195:

Line 341: from wip_operation_resources

337:
338: if(l_cmro_count > 0) then
339: select count(*)
340: into l_count_res
341: from wip_operation_resources
342: where wip_entity_id = p_eam_op_rec.wip_entity_id
343: and organization_id = p_eam_op_rec.organization_id
344: and operation_seq_num = p_eam_op_rec.operation_seq_num;
345:

Line 659: from wip_operation_resources

655: end if;
656:
657: select count(*)
658: into l_count_res
659: from wip_operation_resources
660: where wip_entity_id = p_eam_op_rec.wip_entity_id
661: and organization_id = p_eam_op_rec.organization_id
662: and operation_seq_num = p_eam_op_rec.operation_seq_num;
663:

Line 1030: FROM wip_operation_resources wor

1026: --3. Is Time charged on Operation
1027: BEGIN
1028: SELECT SUM(nvl(applied_resource_units,0))
1029: INTO l_charged_units
1030: FROM wip_operation_resources wor
1031: WHERE wip_entity_id = p_wip_entity_id
1032: AND operation_seq_num = p_op_seq_num;
1033:
1034: IF l_charged_units > 0 THEN