APPS.EAM_SUB_RESOURCE_VALIDATE_PVT dependencies on WIP_OPERATIONS

Line 174: from wip_operations wo

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

Line 567: wip_operations wo

563: begin
564:
565: -- Check whether sub resource dept and op dept match.
566: select 1 into g_dummy from
567: wip_operations wo
568: where wo.wip_entity_id = p_eam_sub_res_rec.wip_entity_id
569: and wo.organization_id = p_eam_sub_res_rec.organization_id
570: and wo.operation_seq_num = p_eam_sub_res_rec.operation_seq_num
571: and wo.department_id = p_eam_sub_res_rec.department_id;