APPS.EAM_RES_VALIDATE_PVT dependencies on WIP_OPERATIONS

Line 176: from wip_operations wo

172: if (p_eam_res_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
173:
174: select 1
175: into g_dummy
176: from wip_operations wo
177: where wo.organization_id = p_eam_res_rec.organization_id
178: and wo.wip_entity_id = p_eam_res_rec.wip_entity_id
179: and wo.operation_seq_num = p_eam_res_rec.operation_seq_num;
180:

Line 347: wip_operations wo,

343: -- baroy - check whether the resource specified belongs to the department of the operation
344: select
345: 1 into g_dummy
346: from
347: wip_operations wo,
348: bom_departments bd,
349: bom_department_resources bdr
350: where
351: wo.organization_id = p_eam_res_rec.organization_id

Line 637: wip_operations wo

633: begin
634:
635: -- Check whether resource dept and op dept match.
636: select 1 into g_dummy from
637: wip_operations wo
638: where wo.wip_entity_id = p_eam_res_rec.wip_entity_id
639: and wo.organization_id = p_eam_res_rec.organization_id
640: and wo.operation_seq_num = p_eam_res_rec.operation_seq_num
641: and wo.department_id = p_eam_res_rec.department_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