DBA Data[Home] [Help]

APPS.EAM_RES_VALIDATE_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 901: from wip_op_resource_instances

897: begin
898: if (p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
899: select count(*)
900: into l_count_inst
901: from wip_op_resource_instances
902: where wip_entity_id = p_eam_res_rec.wip_entity_id
903: and organization_id = p_eam_res_rec.organization_id
904: and operation_seq_num = p_eam_res_rec.operation_seq_num
905: and resource_seq_num = p_eam_res_rec.resource_seq_num