DBA Data[Home] [Help]

APPS.EAM_RES_VALIDATE_PVT dependencies on WIP_OPERATION_RESOURCES

Line 291: from wip_operation_resources wor

287:
288: begin
289: select 1
290: into g_dummy
291: from wip_operation_resources wor
292: where wor.organization_id = p_eam_res_rec.organization_id
293: and wor.wip_entity_id = p_eam_res_rec.wip_entity_id
294: and wor.operation_seq_num = p_eam_res_rec.operation_seq_num
295: and wor.resource_id = p_eam_res_rec.resource_id;

Line 652: FROM wip_operation_resources wor, wip_operations wo

648:
649: -- Check whether trying to update department (which is disallowed).
650: IF p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE THEN
651: SELECT 1 into g_dummy
652: FROM wip_operation_resources wor, wip_operations wo
653: WHERE wor.wip_entity_id = p_eam_res_rec.wip_entity_id
654: AND wo.wip_entity_id = p_eam_res_rec.wip_entity_id
655: AND wor.organization_id = p_eam_res_rec.organization_id
656: AND wo.organization_id = p_eam_res_rec.organization_id

Line 858: from wip_operation_resources

854: end if;
855:
856: select nvl(applied_resource_units,0)
857: into l_applied_res_units
858: from wip_operation_resources
859: where wip_entity_id = p_eam_res_rec.wip_entity_id
860: and organization_id = p_eam_res_rec.organization_id
861: and operation_seq_num = p_eam_res_rec.operation_seq_num
862: and resource_seq_num = p_eam_res_rec.resource_seq_num